Validation not working

[Guest]

I have a textbox that should hold a value no greater than 250 but the
validation doesnt work.

If...
Validation Rule: =[textboxname]>250
or
Validation Rule: =[textboxname]=250

The error message appears regardless of the value in my text box.

If...
Validation Rule: =[textboxname]<250

The error message does NOT appear, regardless of the value in my text box.

The textbox Format is 'General Number' and in its related table, the field
has a data type 'Number', field size 'Double'.

Whats wrong ???

Thanks in advance.

 

[Van T. Dinh]

Don't use the TextBox name. Use:

250

--
HTH
Van T. Dinh
MVP (Access)

I have a textbox that should hold a value no greater than 250 but the
validation doesnt work.

If...
Validation Rule: =[textboxname]>250
or
Validation Rule: =[textboxname]=250

The error message appears regardless of the value in my text box.

If...
Validation Rule: =[textboxname]<250

The error message does NOT appear, regardless of the value in my text box.

The textbox Format is 'General Number' and in its related table, the field
has a data type 'Number', field size 'Double'.

Whats wrong ???

Thanks in advance.

 

[Guest]

Gotcha, thanks

Don't use the TextBox name. Use:

250

--
HTH
Van T. Dinh
MVP (Access)

I have a textbox that should hold a value no greater than 250 but the
validation doesnt work.

If...
Validation Rule: =[textboxname]>250
or
Validation Rule: =[textboxname]=250

The error message appears regardless of the value in my text box.

If...
Validation Rule: =[textboxname]<250

The error message does NOT appear, regardless of the value in my text box.

The textbox Format is 'General Number' and in its related table, the field
has a data type 'Number', field size 'Double'.

Whats wrong ???

Thanks in advance.