Have you tried: 'Character Field' LIKE "%[^0-9]%"
Cheers Peter > Hi there, > > I'm trying to test if a Character Field contains anything but numbers. > I did a test form on that I have a character field and a button. When > I click the button, it fires an Active Link with this RunIf: > > 'Character Field' LIKE "[^0-9]" > > If the RunIf is true, the Active Link shows an error message. > > Here's my test. > > 1. when I enter "1" into the character field and click the button I > get NO message so OK > 2. when I enter "19" into the character field and click the button I > get NO message so OK > 3. when I enter "a" into the character field and click the button I > get THE message so OK > > 4. when I enter "a2" into the character field and click the button I > get NO message and this is NOT OK > > What's wrong with the case 4? > > I thought I've said 'Character Field' LIKE "[^0-9]" which mean, if the > field contains anything but the the numbers from 0 to 9, the Run If is > TRUE and this should cause the error message. As far as I'm concerned > a2 isn't within 0-9, so where is there error message? What am I > missing? > > > Mark > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
