Thats cheating :)
besides, I was trying to avoid bloating my tables with excessive fields that can be calculated on the fly.
I have however found the solution. basically you set the datasource of a text box to
"=IIf( [someotherfield] = "whatever", 'code executed if true', 'code executed if false')
you can get pretty creative with what goes in there and as a result, change...
tg989
Last Activity: Dec 8 '06, 03:44 PM
Joined: Nov 10 '06
Location:
-
I think that the form_current has some potential, I'll try it and see what happens!
btw the reason I said that continuous forms was possibly the best feature is because it would take you several weeks to make a datagrid in vb.net that gives you the same effect. Everything else that access has going for it, some other language/ide can do better.
PEB - your suggestion only works when you have 1 label... if you have several,...Leave a comment:
-
Deeper than conditional formatting... possible?
Okay, here goes.
Continuous forms... possibly the best feature of access. The only downside is this: the only way to have a conditional evaluation run on each record invididually is by conditional formatting... this poses a problem because it is extremely limited (no wildcards, cannot access controls other than the one the formatting is on, cannot perform evaluations other than the ones give... greater than, less than etc).
...
No activity results to display
Leave a comment: