Command does not work if user has not filled in a feild

[oggsta]

After the user hits the button in an Access form, i would like a VB program to determine

If a field is blank, named [dcfdate]a message appears to say date feild is blank, please update information and hit the button again.

Otherwise it runs the command to generate with word.

Any help appreciated. Regards

 

[jrbarnett]

Easy...

if len ([dcfdate] & "&quot > 0 then
' run program
else
msgbox "you haven't entered information. please do it and try again", vbOkOnly+vbInformation
end if

 

[oggsta]

Yes thanks very much