Hi Ralf ---
Try testing for EMPTY on the bound data (the controlsource)
IF EMPTY(boundtable.boundfield)
ENDIF
>Hello,
>
>I am using a form with some text controls bound to a table.
>When I click on a command button they following code will run:
>
>....
>if alltrim(thisform.artnr.value) = ""
> =Messagebox("Message",48,"Achtung")
> return
>endif
>
>I am trying to verify if a form field is filled or not.
>But it doesn't work.
>Equal to the value the messagebox appears every time. :-(((((
>
>Sorry about my english.
>
>Can anybody help me?
>
>regards Ralf
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05