G Guest Jun 8, 2005 #1 How can I code a field on a form so that all eleven characters are keyed in. TIA
R Rick B Jun 8, 2005 #2 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).
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).
G Guest Jun 8, 2005 #3 I do not want to an input mask on the table- thanks anyway. -- Steve COA-NM Rick B said: 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 Steve COA-NM said: How can I code a field on a form so that all eleven characters are keyed in. TIA Click to expand... Click to expand...
I do not want to an input mask on the table- thanks anyway. -- Steve COA-NM Rick B said: 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 Steve COA-NM said: How can I code a field on a form so that all eleven characters are keyed in. TIA Click to expand... Click to expand...
R Rick B Jun 8, 2005 #4 Then use conditional formatting. -- Rick B Steve COA-NM said: I do not want to an input mask on the table- thanks anyway. -- Steve COA-NM Rick B said: 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 Steve COA-NM said: How can I code a field on a form so that all eleven characters are Click to expand... keyed in. TIA Click to expand... Click to expand... Click to expand...
Then use conditional formatting. -- Rick B Steve COA-NM said: I do not want to an input mask on the table- thanks anyway. -- Steve COA-NM Rick B said: 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 Steve COA-NM said: How can I code a field on a form so that all eleven characters are Click to expand... keyed in. TIA Click to expand... Click to expand... Click to expand...
R Rick B Jun 8, 2005 #5 Oops, not conditional formatting, What was I thinkng? VALIDATION RULE is what I meant to say. Sorry about that. -- Rick B Steve COA-NM said: I do not want to an input mask on the table- thanks anyway. -- Steve COA-NM Rick B said: 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 Steve COA-NM said: How can I code a field on a form so that all eleven characters are Click to expand... keyed in. TIA Click to expand... Click to expand... Click to expand...
Oops, not conditional formatting, What was I thinkng? VALIDATION RULE is what I meant to say. Sorry about that. -- Rick B Steve COA-NM said: I do not want to an input mask on the table- thanks anyway. -- Steve COA-NM Rick B said: 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 Steve COA-NM said: How can I code a field on a form so that all eleven characters are Click to expand... keyed in. TIA Click to expand... Click to expand... Click to expand...
M Michael J. Strickland Jun 8, 2005 #6 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
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
