How do we allow Canadian addresses in our database 1

[3587ch]

I have a database and it is setup for USA address format
Street, City, State (AB), Zip.

What would I need to do let a user enter Canadian addresses?

I know it's a silly question.

Thank you,

 

[Turkbear]

Hi,
It depends on what restrictions that field in the database now has...It there an edit mask/validation code or just a length limitation?



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
Also, you should probably change the name of the field called State to StateOrProvince and Zip to PostalCode



To Paraphrase:"The Help you get is proportional to the Help you give.."