|
| 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
November 21st, 2005, 05:09 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
November 21st, 2005, 05:36 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
November 21st, 2005, 05:43 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 |
Linear Mode
