Indicate on Form if Value exists

  • Thread starter Thread starter andrewbda
  • Start date Start date
A

andrewbda

Hi,

I have a simple form with 5 fields. Instead of displaying the content
in one of the fields, I would simply like the form to indicate whether
the field contains a value or not.

I think this could be achieved through a checkbok or even a textbox
that says either "yes" or "no."

Can anyone offer any ideas?

Many thanks,

Andrew
 
Set the Control Source of your check box (or text box) to:
=([Field1] Is Not Null)
replacing Field1 with the name of your field.

It will be read-only, of course.
 
Allen,

it works perfectly, thanks alot!


Allen said:
Set the Control Source of your check box (or text box) to:
=([Field1] Is Not Null)
replacing Field1 with the name of your field.

It will be read-only, of course.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a simple form with 5 fields. Instead of displaying the content
in one of the fields, I would simply like the form to indicate whether
the field contains a value or not.

I think this could be achieved through a checkbok or even a textbox
that says either "yes" or "no."

Can anyone offer any ideas?

Many thanks,

Andrew
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test form for changes on close 6
Red text or background if control contains a certain value? 2
COMPARING VALUES IN FORM/SUBFORM 3
Check if a date exists in a record 1
Display decimal value in textbox 5
Parameter Value error in a Subform 0
Access MS access forms list box problems 1
Check if folder path exists 4

Back
Top