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
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,

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

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
May 28 '07 #2

Post your reply

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