Make Table Formatting Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a make table query and in one of the query's fields
I have it taged to a text box in a form so the user knows
when the data is made that the data is for say client 6610
but when the table is made the field is made as a Binary
type (not) text is their a way I can fix that? I need it
to be text!
 
I have a make table query and in one of the query's fields
I have it taged to a text box in a form so the user knows
when the data is made that the data is for say client 6610
but when the table is made the field is made as a Binary
type (not) text is their a way I can fix that? I need it
to be text!
Click to expand...

Use the CStr() function around the reference to the form's TextBox. E.g.:

CStr(Forms!FormName!ControlName)
 
Back
Top