August 6, 200421 yr Canadians as well as those of the "British Empire" do things a little differently when it comes to postal codes. Our system uses 7 characters { Letter # Letter space # letter #} i.e. B2S 1L7. Having worked with MS Access I would simply format the input mask as "L>L >L>". As a result the data that I would enter would be displayed as shown in the example, even though the key strokes were small letters. Similarly when entering phone numbers with area code I would format the input mask as !(999") "000-0000;0;_ Are there similar formating structures in FM? space
Create an account or sign in to comment