want to check if formfield is empty ...how?

[Haanz]

hi everyone

i 'm a little bit desperate. normal i think, doesn't it?
i want to check if a formular is empty, but it doesn't really work!
a part of my coding(not finished yet):

Dim var As Fields
Set var = Form_frmAblaufsachen.txtNummer

how can i give variable a value of a form or a field?
at first i ve tried to check the form for emptiness.
after that i ve given up to check the whole form in this way so i ve tried to check only one field of the form(see over this text).
i hope someone can help me.
best wishes

 

[mrf1xa]

Hi Haanz

Hope I've understood you right. You can check a field on a form for emptiness like this:

If IsNull(Forms![frmAblaufsachen]![txtNummer]) Then
...Do Something.....
Else
....Do Something else
End If

Hope this helps

Nigel


Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....

 

[Haanz]

hi nigel,

i thank you for your help. however we have found another way to solve the problem in future, if i have a problem with VB or VBA i hope to get your help again.

best wishes

haanz