Hi, all!
I want to highlight the active control, as the cursor is difficult to see from time to time. I saw, at another forum, that you could write a sub, place it in a module and refer to it in the form properties window, selecting multiple fields at the same time.
When trying to, i get an error stating (translated from norwegian,some words maynot be the ones used in the english statement)
"The expression selected as the event property caused the error "Object does not contain the automation object setYellow"
Code is
sub setYellow
if me.activecontrol.controltype= actextbox or me activecontrol.controltype=accombobox then
me.activecontrol.forecolor=vbyellow
end if
end sub
This is placed in a module
It is referred to in the form properties pane, onenter event, as =[setYellow]
But does not work....
Any ideas?
Best regards
vargan
I want to highlight the active control, as the cursor is difficult to see from time to time. I saw, at another forum, that you could write a sub, place it in a module and refer to it in the form properties window, selecting multiple fields at the same time.
When trying to, i get an error stating (translated from norwegian,some words maynot be the ones used in the english statement)
"The expression selected as the event property caused the error "Object does not contain the automation object setYellow"
Code is
sub setYellow
if me.activecontrol.controltype= actextbox or me activecontrol.controltype=accombobox then
me.activecontrol.forecolor=vbyellow
end if
end sub
This is placed in a module
It is referred to in the form properties pane, onenter event, as =[setYellow]
But does not work....
Any ideas?
Best regards
vargan