Curreny value in ms access field.

**aligahk06** · 01-28-2021, 05:25 AM

Dear All,

i have a table and form with this attachment.
I want to add project cost field like SAR 2.250.0
But while adding project cost it display like for eg. $ 2,250.00.

**ranman256** · 01-28-2021, 06:01 AM

2.250.0 is not a numeric value.
2,250.00 (US)
or
2.250,00 (non US)

treat the field as 2,250 but display (format) as non US format.

**mike60smart** · 01-28-2021, 06:21 AM

Hi

Change the Format of the Control on the Form to this:- "SAR "#,##0.00

**aligahk06** · 01-28-2021, 07:23 AM

Please assit me please how to change format of the control on form.

**mike60smart** · 01-28-2021, 07:38 AM

Hi

See that attached

**Welshgasman** · 01-28-2021, 07:41 AM

You use the Format property?

**aligahk06** · 01-28-2021, 08:15 AM

Thank you done!
I stuck on somewhere else.

**mike60smart** · 01-28-2021, 08:35 AM

What are you stuck on?

Curreny value in ms access field.

Thread Tools

Curreny value in ms access field.

Similar Threads

I want to click on a field on an access form and search google maps for the field content

Inserting time into Access 2010 query field when a charater is entered in that field

Reading field from Access to labels problem (missing returns in field)

How to solve Access limitation of a memo field mapped to nvarchar(max) field in SQL

Query criteria - only show curreny July - July period

Posting Permissions