is it possible in a split form to have the value of txtgo be different colors based on the value? 1 would be green, 2 would be yellow and 3 would be yellow. I know how to do it in a single form but not a split or continuous form.
is it possible in a split form to have the value of txtgo be different colors based on the value? 1 would be green, 2 would be yellow and 3 would be yellow. I know how to do it in a single form but not a split or continuous form.
Use Conditional Formatting properties, not VBA.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
that works on a split form? I gave it a shot earlier but didn't think it would work so I moved on. i'll try again, any tricks? if looking for not null?
Yes, it works on split form.
Not sure what you mean by 'if looking for not null'. No IIf() is involved.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
thanks june7
FYI, Conditional Formatting works on any type of Form! But it is the only way to do this type of Formatting on a Datasheet View or Continuous View Form. And since a Split Form involves a Datasheet View...you have to use Conditional Formatting for this.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007