Make Table Query data type conversion 1

[hengsin]

i have one Make Table query. One of field is Location. It is used to let user to key in the Location such as China, US etc. On that field, i put the following syntax on it: Location: [Please enter Location}.

But when i open up the table in Design Mode, i noticed that the Data Type for that field is Binary. The data type i want is Text. Any idea to solve this problem?

 

[dhookom]

Try
Location: CStr([Please enter Location])
or
Location: Left([Please enter Location],200)



Duane
MS Access MVP

 

[hengsin]

you deserved a star. I used the first method that you suggested.