Input Mask creating Problem for Search combo

R

Rich1234

Hi

I am using an unbound combo to search for a record on a form. The
underlying fields which appear in the combo come from a table whose input
mask is
Aaaaaaa (ie all letters are capitals, 1st character is required, other 6 are optional and all characters are either letters or numbers.)
Click to expand...
For consistency, how can I ensure that any letters typed into the combo for
searching are also in capitals? (It works if lower case is entered, just
doesn't look as professional as it might onscreen.) When I try using the
same input mask into the combo, it works, but I get the following problem:
if the user clicks midway in the searchbox to enter the value to search for,
the cursor appears midway in the field which means that character input
starts halfway through the string to search for. I know how to fix this with
a normal textboxwhich uses the mask, by setting the OnClick event as follows:
Me.FieldName.SelStart = 0
Me.FieldName.SelLength = 7

However this does not fix the problem in a combo.
Is this possible? Do you know how?
I'd be grateful for your help.
Thanks
Rich
 
Top