S
Secret Squirrel
I've been using the conditional formatting to change the backcolor of a field
on my form when that field has the focus. Sorta like hightlighting the field
the cursor is in.
Is there a way to set this up in VBA code instead of using the conditional
formatting under the format menu? The reason I ask is because when a user
opens the form the record is locked and cannot be modified but they can click
on a field if they want but they can't update it until the hit the modify
command button I have on the form. I don't want the conditional formatting to
change the backcolor of the field that has the focus until the modify command
button is clicked. Then when they click the save command button it will shut
off the conditional formatting. It confuses them because they think when the
backcolor is changed for the field that has the focus they think they can
modify it. But they actually have to click the modify button first. Is there
a way to set this up in a module and then call it from the command buttons
onclick event?
on my form when that field has the focus. Sorta like hightlighting the field
the cursor is in.
Is there a way to set this up in VBA code instead of using the conditional
formatting under the format menu? The reason I ask is because when a user
opens the form the record is locked and cannot be modified but they can click
on a field if they want but they can't update it until the hit the modify
command button I have on the form. I don't want the conditional formatting to
change the backcolor of the field that has the focus until the modify command
button is clicked. Then when they click the save command button it will shut
off the conditional formatting. It confuses them because they think when the
backcolor is changed for the field that has the focus they think they can
modify it. But they actually have to click the modify button first. Is there
a way to set this up in a module and then call it from the command buttons
onclick event?