Change backcolor of textbox in DataSheet view 1

[kermitforney]

I would like to change the backcolor of a textbox to grey (RGB(128,128,128), After Update. The issues I am having are, one, VBA is not effective and does not change the back color

 randtxtboxname.BackColor = RGB(128, 128, 128)

and , second, the only other way I know of accomplishing this is with Conditional Formatting, but I am not sure if this is possible comparing with a past value. In other words, I am not sure how to get Conditional Formatting to function upon and Edit action.

Any help is greatly appreciated. Thanks.

 

[dhookom]

If you want to set the formatting for only the current record in datasheet (or continuous), you will need to use conditional formatting. Any other code to set a property will show the same formatting for every record.

Conditional formatting relies on an expression that can be calculated from a single record. Are you storing anything in your record that identifies the textbox has been updated?

Duane
Hook'D on Access
MS Access MVP

 

[kermitforney]

Are you storing anything in your record that identifies the textbox has been updated?

In the backend, yes via trigger, but nothing that I am pulling for the front end.

 

[dhookom]

I doubt you have any ability to format a single text box without some way to identify the condition.

Duane
Hook'D on Access
MS Access MVP

 

[kermitforney]

Thanks anyway Duane!

 

[missinglinq]

Could we see an example of the condition(s) you're talking about? Perhaps you could use the AfterUpdate event to assign a value to a hidden, bound field, then use this field's value as a condition for Conditional Formatting, using the "Expression Is" construct.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!