Design view

[Rich]

I have a field which is in Data Type Text:
Which has the below values inserted.

$2,000,000.

Anyway under format to remove the $, . from the value.

I cannot use Data Type Number because the field contains
text and will not import.

Thanks,

Rich

 

[John Vinson]

I have a field which is in Data Type Text:
Which has the below values inserted.

$2,000,000.

Anyway under format to remove the $, . from the value.

I cannot use Data Type Number because the field contains
text and will not import.

Thanks,

Rich

You can't do so using the Format property (which in any case has no
effect on what's stored in the table).

An Update query will work though; if you have AccessXP or later,
update the field to

Replace(Replace([fieldname], "$", ""), ",", "")

 

[Guest]

Thanks

-----Original Message-----

I have a field which is in Data Type Text:
Which has the below values inserted.

$2,000,000.

Anyway under format to remove the $, . from the value.

I cannot use Data Type Number because the field contains
text and will not import.

Thanks,

Rich

You can't do so using the Format property (which in any case has no
effect on what's stored in the table).

An Update query will work though; if you have AccessXP or later,
update the field to

Replace(Replace([fieldname], "$", ""), ",", "")



.