background color value (1 Viewer)
- Thread starter mcat
- Start date
- Local time
- Yesterday, 23:38
- Joined
- Oct 29, 2018
- Messages
- 21,454
Hi. I can't download your file at the moment. What control are you trying to change the color? Sometimes, you could use a workaround by using a Textbox to represent it, so you can apply conditional formatting.
- Local time
- Yesterday, 23:38
- Joined
- Oct 29, 2018
- Messages
- 21,454
Of what/which control though? Are you talking about for the Form itself?
isladogs
MVP / VIP
- Local time
- Today, 07:38
- Joined
- Jan 14, 2017
- Messages
- 18,209
Is the attached what you want? If so black text may be better when the background is yellow.
I used conditional formatting as previously suggested by others.
Strongly recommend your field names do not contain spaces or special characters
I used conditional formatting as previously suggested by others.
Strongly recommend your field names do not contain spaces or special characters
isladogs
MVP / VIP
- Local time
- Today, 07:38
- Joined
- Jan 14, 2017
- Messages
- 18,209
OK then - like this ? I hope so! 
I've removed the previous conditional formatting from v2
To do the above I've had to use the Detail_Format event as CF can't be used on box controls
However that event only runs in print preview or when printed.
You won't see the effect in report view or layout view.
That cannot be done!
Hope that helps
NOTE: You should also remove special characters like / from field names
I've removed the previous conditional formatting from v2
To do the above I've had to use the Detail_Format event as CF can't be used on box controls
However that event only runs in print preview or when printed.
You won't see the effect in report view or layout view.
That cannot be done!
Hope that helps
NOTE: You should also remove special characters like / from field names
