G
Guest
How do I determine whether a controls value is blank or unselected from code? This could be a textbox, combo or list bo
Jonh H
Jonh H
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Use the IsNull() function.
Presumably you know the name of the form, and the name of the control, so:
If IsNull(Forms("NameOfYourFormHere").Controls("NameOfYourContolHere")) Then
....
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Presumably you know the name of the form, and the name of the control, so:
If IsNull(Forms("NameOfYourFormHere").Controls("NameOfYourContolHere")) Then
....
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
code? This could be a textbox, combo or list boxJohn H said:How do I determine whether a controls value is blank or unselected from