Validation not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Don't use the TextBox name. Use:
250
Click to expand...

--
HTH
Van T. Dinh
MVP (Access)



Widemonk said:
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.
Click to expand...
 
Gotcha, thanks :D

Van T. Dinh said:
Don't use the TextBox name. Use:
250
Click to expand...

--
HTH
Van T. Dinh
MVP (Access)



Widemonk said:
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.
Click to expand...
Click to expand...
 
Back
Top