Textbox data validation rules.....

[smorelandii]

Hello all...... I'm really having issues with my validation logic rule tied to a textbox in a subform. Someone please help! My head hurts... LOL! Been looking at this stuff to long today. I need to force a numeric value in a text box that will allow NULL and decimal. I realize I could change the table field data type to decimal but that is not an option here.

Allow these characters in a text box:


1 2 3 4 5 6 7 8 9 0 . NULL

Heres what I have so far.... This allows numbers but not decimals

Is Null Or Not Like "*[!0-9]*"

[smorelandii]

Figured it out....

(Is Null) Or (Not Like "*[!0-9]*" And Between 30 And 240) Or (Like "*.*")

and used BeforeUpdate to check the Len().....

Thanks tho........