Richard: I have a combobox on my form, In that combobox there is 3 items, 1 first report of incident 2 Updated report of incident 3 final report of incident what i am looking to do is when i enter first report i want my form to turn to red. when i enter the update report i want my form to be yellow. when i enter the final report i want the form to turn to green any words of of advice for me
Hi I did one like that had a combo box with started, not completed and finished and used conditional formatting.
Kevin Robertson
@Reply 4 years ago
You can't change the colour of the form with conditional formatting.
Juan C Rivera
@Reply 4 years ago
I did a continues form with I think it was expert level 19.
Juan C Rivera
@Reply 4 years ago
Brian did you see todays tech help video rather than changing the form color how about changing the fields background color?
Scott Axton
@Reply 4 years ago
Take a look at the Conditional Formatting video as well. That might help you to do what you are looking at doing.
Brian SmithOP
@Reply 4 years ago
Thank you all for the help, here is what i have come up with
oh the combobox is named Category
IF Category = "**FIRST**REPORT OF INCIDENT" THEN
Me!FORM = rgb (255,0,0)
end if
I don't understand what you're trying to do. Do you have three combo boxes on one form in one record or are we talking about three separate records with three separate combo boxes. You can't select three items in one combo box. You can select three items in a multi-select list. And you can have three columns in the combo box but that's something completely different. Screenshots would be helpful.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 1.
