Limiting a field to a particular string

[canjfn]

On My form I would like to have code to limit what can be put into a field e.g

If Me.Myfield is not = to A, B or C
then
message
"You must enter A, B or C in this field"
EndIf

Any help please ?

 

[RuralGuy]

Use a ComboBox with RowSourceType set to ValueList and Limit to list set to yes.

 

[Pat Hartman]

RuralGuy's suggestion is the best method buy just FYI, I'll show you the correct If statement:

If Me.Myfield not = to "A" AND Me.Myfield not = "B" AND Me.Myfield not = "C" then

 

[RuralGuy]

Hi Pat,

I think someone we both know must be sleepy.

If Me.Myfield not = to "A" AND Me.Myfield not = "B" AND Me.Myfield not = "C" then

How about:

If Me.Myfield <> "A" AND Me.Myfield <> "B" AND Me.Myfield <> "C" Then

Merry Christmas!

 

[neileg]

Wouldn't a 'not in()' statement be more elegant

 

[Pat Hartman]

I think someone we both know must be sleepy.

That's what happens when you answer questions in your sleep Thanks for fixing it.

Wouldn't a 'not in()' statement be more elegant

True but we had already suggested that the combo was a better solution so I didn't want to confuse the issue. The entire point of my post was to show the syntax for a complex compound conditional statement because most people have such trouble with them. English syntax and boolean syntax are different and no one seems to teach boolean logic any more. However, I failed miserably since I was sleeping when I copied and pasted the code

 

[neileg]

Hi Pat. I wasn't trying to be clever. I would use a combo, too. I just get frustrated when my colleagues use extended statements (usually in Excel, however) that replicate built in functions. I guess I have my eyes tuned for that kind of thing.