View Single Post
Old 07-11-2019, 10:53 PM   #4
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 2,125
Thanks: 3
Thanked 462 Times in 455 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: Forcing A Field's Data Type To Be Currency In Dollars ($) Instead Of Regional Set

You could use
Code:
format(nnn.nn, chr(163) & "#.##")
where nnn.nn is an amount

However, a field set to this will not be updatable.
Cronk is offline   Reply With Quote