Required characters in a field.

[Guest]

How can I code a field on a form so that all eleven characters are keyed in.

TIA

 

[Rick B]

One way would be to use conditional formatting to verify...
Len([SomeFieldName])=11

I think an INPUT MASK will also work for you. (use the help file).

 

[Guest]

I do not want to an input mask on the table- thanks anyway.
--
Steve COA-NM

One way would be to use conditional formatting to verify...
Len([SomeFieldName])=11

I think an INPUT MASK will also work for you. (use the help file).

--
Rick B

How can I code a field on a form so that all eleven characters are keyed in.

TIA

 

[Rick B]

Then use conditional formatting.


--
Rick B

I do not want to an input mask on the table- thanks anyway.
--
Steve COA-NM

One way would be to use conditional formatting to verify...
Len([SomeFieldName])=11

I think an INPUT MASK will also work for you. (use the help file).

--
Rick B

How can I code a field on a form so that all eleven characters are

keyed
in.

TIA

 

[Rick B]

Oops, not conditional formatting, What was I thinkng?

VALIDATION RULE is what I meant to say.

Sorry about that.


--
Rick B

I do not want to an input mask on the table- thanks anyway.
--
Steve COA-NM

One way would be to use conditional formatting to verify...
Len([SomeFieldName])=11

I think an INPUT MASK will also work for you. (use the help file).

--
Rick B

How can I code a field on a form so that all eleven characters are

keyed
in.

TIA

 

[Michael J. Strickland]

Assuming your entries are going into a textbox (i.e. TextBox), put a check
in the
BeforeUpdate event like:


Private Sub TextBox_BeforeUpdate(Cancel As Integer)

If Len(TextBox) <> 11 Then
Cancel = True
End If

End Sub

 

[Guest]

Michael - That is it! All code and clean!!!

Thanks