dre-logics -1 Junior Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.