input mask problems

[rudeman76]

Hey again,

I have a form (columner style) that the user enters in info from bags that come in. once the user selects an area (from a drop down box), this determines the input mask for the next text box. This works alright, but my problem is that when the input mask changes, it changes it for all the records. I have two different masks.

Private Sub txtHoleNo_GotFocus()
 
if cboArea.value="LDD" then
    txtHoleNo.inputmask="\000;0"
else
   txtHoleNo.inputmask="\00\-000;0"
end if
end sub
 

Andrew

[Rabbit]

There's nothing you can do about that. It's the way that Access works. The only thing you can really do is use a non-continuous form and use the On Current event to get the correct input mask each time.