How to create a format in thousand of dollars?

[evilman]

Hi.
I'd like to format some of my fields in thousand of dollars.

For example, instead of displaying 1,000,000$, it would display 1,000$.

In reports, I was doing a division by 1000 (control source= [field] /1000). Unfortunatly, I can't do this in read/write field on a form, and that's normal.

Any ideas?

Thanks.

 

[Shadez]

Setting the control source to


"= [field] /1000"

should work fine, i have just tested it.

 

[evilman]

that's strange, I get a "#Error" when I do that.
I even tried to do a simple "=[Field]", but I still get a #Error.
When I just type [Field] it works, though.

 

[Rich]

remove the quotes =[yourfield]/1000

 

[evilman]

Hmm, sorry about the confusion.
I did remove the quotes.

 

[Mile-O]

If your value is a number and not a currency then this format will do for you. You shouldn't have to include the dollar sign if the field is already set to currency.

Format:

#,###,$

 

[evilman]

works like a charm!!
thanks a lot.