What would be the equivalent of OnFormat (Reports), but on Forms?
What would be the equivalent of OnFormat (Reports), but on Forms?
There isn’t as far as I know - the facilities for printing forms is much more limited than printing reports
what is it you are trying to achieve?
I have a form that we are using as a "display screen" to show real-time updates
I am currently using Conditional formatting on the form which works. However, it doesn't work while the form is requerying from our IS system, which could take a few minutes.
It only works when the form is not querying / processing.
I was hoping i could create 3 text boxes with 3 colored background (green,yellow,red) and perhaps have them be "visible" based on a value. But, wasn't sure what event to attach that to.
Any ideas are appreciated
Ok - so same question as your other thread which I have responded to.
crosspost is suggesting the same things I did in the OP's other post. What a waste of time, Don't know why I bother
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba