G Guest May 24, 2004 #1 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
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
A Allen Browne May 24, 2004 #2 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. John H said: How do I determine whether a controls value is blank or unselected from Click to expand... code? This could be a textbox, combo or list box
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. John H said: How do I determine whether a controls value is blank or unselected from Click to expand... code? This could be a textbox, combo or list box
