Limit input into a bound Textbox


Author
Message
Terry Bottorff
Terry Bottorff
Advanced StrataFrame User (778 reputation)Advanced StrataFrame User (778 reputation)Advanced StrataFrame User (778 reputation)Advanced StrataFrame User (778 reputation)Advanced StrataFrame User (778 reputation)Advanced StrataFrame User (778 reputation)Advanced StrataFrame User (778 reputation)Advanced StrataFrame User (778 reputation)Advanced StrataFrame User (778 reputation)
Group: Forum Members
Posts: 448, Visits: 12K
The following is the definition of the field in the database: [Event] [char](2) NOT NULL, and the following is what I have as the default in the database: DEFAULT ('') FOR [Event].



How do I limit the user from entering only CC in the bound text box on a form or leaving it blank? If the user enters anything else I want to set it back to '' and return to the input form.



I have tried using the CheckRulesonCurrentRow like the following but it does not seem to work:



if me.sportbo.event <> "CC" and me.sportbo.event <> "" THEN

return False

endif



I have also tried me.sportbo.event <> " " AND me.sportbo.event <> " " (one space and two spaces between the "").

I also tried me.sportbo.event <> string.empty



It should be easy I think. TIA







GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Terry Bottorff - 15 Years Ago
Edhy Rijo - 15 Years Ago
             Makes sense thank you.
Terry Bottorff - 15 Years Ago
Edhy Rijo - 15 Years Ago
                     Alright I'll think about that. Thanks.
Terry Bottorff - 15 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search