Full Version: Format With Brackets
UtterAccess Forums > Microsoft® Access > Access Forms
connorgraham
Quick Question:
That is the best way to format a number textbox on a form in brackets --- without losing the standard data formatting:
ie (250,000) instead of -25
LPurvis
If I understand your requirements...
In a query:
Format([FieldName],"#,###;(#,###)")
On a form control format property:
#,###;(#,###)
Cheers.
Edited for improvement for what you probably want...
connorgraham
thanks
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.