If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
instead of - for numbers
Anyone have any hints on how to show a negative number as 100 rather than
-100 in an Access datasheet form, or in general. Thanks |
#2
|
|||
|
|||
instead of - for numbers
Steve,
Try setting the format property for the control to something along these lines... #;#;0 -- Steve Schapel, Microsoft Access MVP Steve wrote: Anyone have any hints on how to show a negative number as 100 rather than -100 in an Access datasheet form, or in general. Thanks |
#3
|
|||
|
|||
instead of - for numbers
On Mon, 21 Nov 2005 09:09:06 -0800, Steve wrote:
Anyone have any hints on how to show a negative number as 100 rather than -100 in an Access datasheet form, or in general. Thanks With comma separated thousands, and 2 decimal places? Set the control's Format property to #,##0.00;#,##0.00;0.00 In Access help look up Format + Number and Currency datatype -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
compare not and | neeraj | Running & Setting Up Queries | 6 | November 4th, 2005 12:55 AM |
URLS in outlook display with | Paul | General Discussion | 1 | October 11th, 2005 12:40 AM |
Open Insert...? | Kenneth | General Discussion | 2 | October 10th, 2005 11:50 PM |