In a Visual Basic 2008 windows application + MySQL database.
I have a MaskedEdit field used for phone numbers, the mask is (###) ### - ####
In my Table1 , i have a record with two fields:
1. Field Name (string 15)Data "andre"
2. Field Phonenr (string 25)Data " " ( field is empty ).
Maskedbox1.mask="(###) - ### - ####"
Maskedbox1.SelLength = 25
MaskEdBox1.PromptChar = "_"
MaskEdBox1.DataFormat.Format = "(###)-###-####"
MaskEdBox1.DataSource = MyTable1
MaskEdBox1.DataField = phonenr
Binding a masked edit to a data control can result in the following error message when the form is loaded:
Invalid property value.
Additionally, the following error can occur when you attempt to update a record:
Type mismatch
My question is how can I prevent these errors