how do save a field with a currency type? will it be the same on saving a
number field?
e.g. insert into table(amount) values(" & me.txtAmount & ")
This expression will save whatever is in txtAmount into the field [Amount] in
your table. It will not change the datatype of that table field; you need to
do so in table design view. If the table was created with Amount as a Number
field it will be a Number field, if it was created with a Currency field then
it will be currency, etc.
You can change the format of a table field, or display a field in a textbox
with its Format property set to Currency; that's a different issue than the
datatype of the field.
