StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Limit input into a bound Textbox

Limit input into a bound Textbox

Terry Bottorff — Tue, 17 Nov 2009 20:08:27 GMT

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

RE: Limit input into a bound Textbox

Terry Bottorff — Tue, 17 Nov 2009 20:08:27 GMT

Alright I'll think about that. Thanks.

RE: Limit input into a bound Textbox

Edhy Rijo — Tue, 17 Nov 2009 18:26:19 GMT

Also if you don't mind using an Integer field instead of Character, you can create a Public Enum with the values allowed and bind the combobox to that Enum and that will take of the problem. I do that all the time for very short lookup options.

RE: Limit input into a bound Textbox

Terry Bottorff — Tue, 17 Nov 2009 16:36:42 GMT

Makes sense thank you.

RE: Limit input into a bound Textbox

Edhy Rijo — Tue, 17 Nov 2009 15:49:34 GMT

[quote][b]Terry Bottorff (11/17/2009)[/b][hr]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.[/quote]
Hi Terry,

There are many ways to do this, but if they can only enter some specific data, then use a ComboBox and either preset the values or use a lookup table.