By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,479 Members | 2,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

input mask problems

P: 58
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.


Expand|Select|Wrap|Line Numbers
  1. Private Sub txtHoleNo_GotFocus()
  2.  
  3. if cboArea.value="LDD" then
  4.     txtHoleNo.inputmask="\000;0"
  5. else
  6.    txtHoleNo.inputmask="\00\-000;0"
  7. end if
  8. end sub
  9.  
Andrew
Oct 16 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,315
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.
Oct 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.