Cursor to left and all Caps in Code Field

[MarkV]

I have a table with CODE number as text. (1234-11-3456). I also have this field in a subform. How do I get the field to start at left, and also make all CAPS. Also where do I do the input mask. In the Table or the Form where it is a subform? Any help will be great...

Best Regards
Mark

[June7]

You can set the input mask property in table but this will not alter already existing textbox on form. Always make sure control properties are set as desired on form. I don't bother with setting properties in table.

Why is CAPS an issue - I don't see any alpha in that example data. Conversion to CAPS can be part of the Input Mask. http://office.microsoft.com/en-001/a...005187550.aspx

What do you mean by 'start at left' - you want cursor to position in front of existing data when control gets focus? This requires code.

[MarkV]

Thank you so much. That was a mistake on my part. I showed the code number only. I also have a field that looks like this (67K4-00-M01U)

[June7]

Example code to set cursor position:

Private Sub cbxLabNum_Enter()
Me.cbxLabNum.SelStart = 0
End Sub

[MarkV]

THANK YOU SO MUCH. I will try that now. I am determind to get this program!