Form validation

[tezread]

I have set up a a validation rules for a text box - 'Is Not Null' and a validation text "please enter date"Howvever when I test it the resulting message is "The Microsoft jet engine does not recognise "as a valid field name or expression"

 

[John Big Booty]

Are you doing this at form or table level?

 

[Galaxiom]

Control and Form Validation Rules must be complete expressions.

Not IsNull(fieldname)

 

[tezread]

I have tried [startdate] Is Not Null but it made no difference

 

[tezread]

trying this at form level

 

[John Big Booty]

Have you tried it at table level?

"Is Not Null" should work there.

 

[missinglinq]

GAH has given you the correct syntax

Not IsNull(fieldname)

why do yoiu insist on using

[startdate] Is Not Null

which is incorrect and doesn't work?

Linq ;0)>

 

[Galaxiom]

Actually any of the expressions including the original Is Not Null should work too.
I was thinking of Conditional Formatting where complete expressions must be used.

The message is very strange and suggests corruption of the form.

 

[missinglinq]

Actually any of the expressions including the original Is Not Null should work too.

I'm interested, where at the Form level will Is Not Null work? Not in VBA code. Not in the Validation Property in Design View. And one has to assume that the Validation is being done at the Form level, since the OP speaks of "validating" a Textbox.

Is Not Null will work, I believe, in Queries/SQL statements, as a Criteria, but that certainly isn't germane to this discussion.

Linq ;0)>

 

[Galaxiom]

I'm interested, where at the Form level will Is Not Null work? Not in VBA code. Not in the Validation Property in Design View.

Well since there is no Validation Rule for a form per se, I don't know what OP actually meant by "at Form level" either.

However it does work as the Validation Rule Property of a textbox. (Access 2007 with an mdb file).