Alright I'll think about that. Thanks.

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.

Edhy Rijo

Makes sense thank you.

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.

Edhy Rijo

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