Change the Input Mask of a Field based on the content of another in Access 1

[CVesta81]

Hello,

Is it possible to change the input mask of a particular field based on the content of another? My example here is I have a field named, "zipcode" and I would like to change the input mask of that field depending if the country field reads, "USA" or "Canada". As you may or may not know, the format of the United States zipcode and the Canadian zip code are very much different. The United States zipcode is 00000-0000 and the Canadian zipcode is xxx xxx. Any thoughts on how to do this?

Thanks,
Chris

 

[Andrzejek]

Did you try something like:

Select Case fldCountry.Text
  Case "USE"
    fldZip.Mask = "#####-###"
  Case "Canada"
    fldZip.Mask = "###-###"
End Select

Have fun.

---- Andy

 

[CVesta81]

I have not. Where would I place such code? Would I use this in the "On Current" part of the form?

 

[CVesta81]

OK,

So here is my code. It doesn't appear to be working. What am I doing wrong?

Private Sub Form_Current()

Me.Country.SetFocus
    
    Select Case Country.Text
        Case "USA"
            Zip.InputMask = "#####-####"
        Case "CANADA"
            Zip.InputMask = "??? ???"
    End Select
    
Me.AddressType.SetFocus
    
End Sub

 

[dhookom]

You don't need to set the focus and should use the default/value property rather than Text. And, you need to tell us what is happening not just "doesn't appear to be working".

Private Sub Form_Current()
    Select Case Me.Country.Value
        Case "USA"
            Me.Zip.InputMask = "#####-####"
        Case "CANADA"
            Me.Zip.InputMask = "??? ???"
    End Select
End Sub

Duane
Hook'D on Access
MS Access MVP

 

[CVesta81]

I got it to work. My only question is I'm assuming this code doesn't work correctly if I have a continuous form with both Canada and USA in the form. I tried it and it seemed to switch back and forth between formats when I would click on the different records. Anyway around this? If not, I can live with these results.

 

[dhookom]

I don't believe there is any way around this on a continuous form. I don't use input masks.

Duane
Hook'D on Access
MS Access MVP

 

[missinglinq]

You could, perhaps, have two Controls, both of which are Bound to the Zipcode Field in the Table.

Then, using Conditional Formatting from the Format Menu or Ribbon, use the Value of the 'country' Field to determine which one of the Controls to Enable and which one to Disable. In this way you can use a different, appropriate Input Mask for each Control.

Like Duane, I don't use Input Masks. IMHO, too much trouble for too little gain!

Linq ;0)>

The Missinglinq

Richmond, Virginia

The Devil's in the Details!