Empty TextBox

A

Abdul Shakeel

Hi All,

I've a form in which I've several text Boxes some of which are must to be
filled by the user I just want that if user dont put data in any required
textbox a custom massage appears asking for filling the data.

for this purpose I want that I make custom function so I could call this
function anywhere I want this validation.
 
S

scubadiver

in VBA you would need to use

if isnull (whatever) then msgbox 'This field requires data'

alternatively you can make it a required field in the table design
 

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

Custom Function 6
Display decimal value in textbox 5
Dynamically update userform label based on textbox 5
Resize textbox in a datasheet 4
Required field on form 0
When does record become dirty? 10
Passing a reference to a textbox to a function 1
Prefix data in a text box 1

Top