By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,420 Members | 1,254 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,420 IT Pros & Developers. It's quick & easy.

hiding label and text control if the value is null in form view

P: 2
Sir,
I'm using Ms Access 2000 for crearting a database based on the information extracted from government reports. My aim is to preapare an information retrieval system.
For this purpose, I have created a table named as 'Index Entries'. The field, named as 'Legislature' of this table has got null values for some records. I want to hide the text box for this field having null values in form views of that particular records.
Kindly guide me to solve this.

Thinking You,

Sephali
May 28 '07 #1
Share this Question
Share on Google+
1 Reply

nico5038
Expert 2.5K+
P: 3,072
Use in the OnCurrent event code for the form:

Expand|Select|Wrap|Line Numbers
  1. IF IsNull(Me!Legislature) then
  2.     me!Legislature.visible = False
  3. else
  4.     me!Legislature.visible = True
  5. end if
  6.  
Nic;o)
May 28 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.