Negative Currency Value

[Rosebud]

Hello,

I'm wondering if I can have a negative currency value in a textbox. I have a field on a form where I'm showing the difference in two dollar amounts. If the difference is negative, I want to show that negative sign, but I also want to show the $ sign for that field. For example: $-18.00 or -$18.00.
What Access does now is if the value is negative, it encloses it within parenthases:
$(18). (The field format is Currency). Any experience or ideas with this subject?

Thanks,
Rosebud

[This message has been edited by Rosebud (edited 06-03-2002).]

[This message has been edited by Rosebud (edited 06-03-2002).]

 

[scottfarcus]

Go to Windows Control Panel.

Then Regional Settings.

Then Currency Tab.

You can change it there.

 

[Rosebud]

Thanks so much Scott, that got it to work. But does that mean that all of my users have to manually do that also? I'm still trying to see if I can write some code that does it automatically. Thanks.

Rosebud

 

[scottfarcus]

Yes, that only changes your workstation.

Each user will have to make that change if that's how they would like to view negative currency.

 

[Rosebud]

I think I found a way around it. What I did instead for my textbox is make the controlsource: ="$" & Format([delta],'#,##0')

So now (for example):

-18296.344 becomes $-18,296

which is exactly what I wanted,and Regional Settings don't matter. I think this should do. Thanks Scott for your help.

Rosebud

 

[Shinta]

Greetings:

Just for the record, this solution worked for me in a smoother way:

= "$" & Format([field],'Standard')

Regards

 

[theDBguy]

Greetings:

Just for the record, this solution worked for me in a smoother way:

= "$" & Format([field],'Standard')

Regards

Hi Shinta. Thanks for sharing, that's good to know. However, were you aware you were replying to a 17-year old thread? Just letting you know...

 

[Shinta]

Oh! Yes...

My thoughts is that this forum is used as an internet resource for answers... so is the case that today I reached this thread and found it useful

 

[theDBguy]

Oh! Yes...

My thoughts is that this forum is used as an internet resource for answers... so is the casas that today I reached this thread and found it useful

No worries. I was just making sure you realized that. Cheers!