Macro to set rich text attribute?

E

EER

I have a situation where I need to color-code rows in a MS Access 2007 table
based on when the data was added to the database.

Since the background highlight feature won't highlight individual rows (only
All Rows), I thought I would set the datatype of a column to Memo/Rich Text,
and change the color of the text in some of the rows in that column (either
the text itself or the background color).

Can anyone suggest a macro that would set the background or text color for a
range of rows in a rich-text Memo-datatyped column?

I will need to do this more than once, so I would need to specify both the
range and color to set when running the macro.

Thanks in advance,

Jack
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing row background from external program 0
Need help modifying code 0
AppleScript - How do I select a text ? 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Match table shading (color) to Visio color/Transparency 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Address Format changed after Migration 0
Select text of a particular shading color (VBA macro) 5

Top