How to convert data type

G

GGill

In my form i have command button 'Update'.
the command button updates from link tables (SQL Server DB) to access tables
data.
When i do my updates i have to go to access tables and manualy change in one
column 'Names' data type from bit to text.
How can i hard coded in my command button 'Update' to convert this data
type???


Thank you for help.
 
A

AccessHelp

Hi GGill,

Can you post the code for your command button "Update"? Usually, if you
convert the data type from number to text, you use the function "str". On
the other hand, if you convert from text to number, you would use "val".

Thanks.
 
G

GGill

The code in this button just opens and runs queries. That's all.
When it's finish it creates table for example;
tblClient where field name 'Names' is data type bit and need to manually
change to text. To automate, it can be done in module or in 'Update' button.
Could you give me specific info on this.
 
Top