type mismatch in a form

  • Thread starter Thread starter BeckyC
  • Start date Start date
B

BeckyC

I have changed some fields from number to text format in the table from which
I have created a form. Even though I have changed the control type to "List
Box" in the form, I still get a "type mismatch" error when trying to enter
data in the form.
 
Is your listbox multiple column? Could it be that column 1 is pulling
numbers from a lookup table?
 
Why did you change the control type to listbox?
was it previously a text box? If it was maybe you need to make it a
textbox and change the format property to text
 
I have changed some fields from number to text format in the table from which
I have created a form. Even though I have changed the control type to "List
Box" in the form, I still get a "type mismatch" error when trying to enter
data in the form.
Click to expand...

These should be two independent actions. What's the Row Source property of
your listbox? What do you want it to display? Why a Listbox anyway?
 
Back
Top