changing back color on transparent field after update

caspermurphy

New Member
Joined
Oct 17, 2003
Messages
17
Good day all,

I tried to search through here to find an answer; I probably did not use the correct wording in my search. I apologize if this has been asked and answered.

I have a form that has embedded picture in it.
The field is set to transparent with black font.

I want to change the font to white and still have the field be transparent after something has been entered.

I have tried conditional formatting to change the font if it is not blank.
This as well Me.FieldToChange.ForeColor = 1677215 'The New color
I have tried this on change, after update. but neither of them seemed to work

I am sure I a missing something.

Thank you for any help and again I apologize if I am asking a question that has been answered in previous posts.

John
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,118,673
Messages
5,573,594
Members
412,537
Latest member
Mohamed_5966
Top