Thread: Data Types
View Single Post
  #2 (permalink)  
Old January 23rd, 2004, 12:47 PM
BethMoffitt BethMoffitt is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Put an invisible label over your field with a caption of NA and when the currency field is null or meets your other conditions, make the label visible and the text box invisible. This will work for your form, but not in the table at which time you will probably need another field, possibly Yes/No field to denote whether it is applicable or not.

Regards,

Beth M
Reply With Quote