|
| 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
July 23rd, 2007, 07:31 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Decimal places..
In my form my Quantity box shows up 18 when it is really 17.5 how do I make
it show 17.5? My format is 0;-0; with decimal places set to Auto.. I dont want it to show decimal places when there is none either.. example 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 
|
|
#2
July 23rd, 2007, 08:52 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
Are you certain the underlying field is set to hold numbers other than
integers? From the description, it sounds like it might need to be changed to a "currency" data type. If your format says to show whole numbers ("0;-0"), and Access is doing that, where's the problem? Take a look in Access HELP for "format"... Regards Jeff Boyce Microsoft Office/Access MVP "stephendeloach via AccessMonster.com" u32891@uwe wrote in message news:759d1ee43b5b2@uwe... In my form my Quantity box shows up 18 when it is really 17.5 how do I make it show 17.5? My format is 0;-0; with decimal places set to Auto.. I dont want it to show decimal places when there is none either.. example 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#3
July 23rd, 2007, 09:19 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
I have 0;-0; as teh forma so when Qty is 0 it wont show anything... When I
change it to General Number or Currency is shows 0... Jeff Boyce wrote: Are you certain the underlying field is set to hold numbers other than integers? From the description, it sounds like it might need to be changed to a "currency" data type. If your format says to show whole numbers ("0;-0"), and Access is doing that, where's the problem? Take a look in Access HELP for "format"... Regards Jeff Boyce Microsoft Office/Access MVP In my form my Quantity box shows up 18 when it is really 17.5 how do I make it show 17.5? My format is 0;-0; with decimal places set to Auto.. I dont want it to show decimal places when there is none either.. example 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#4
July 23rd, 2007, 10:45 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
Take another look at the underlying table fields -- what data type are
these? Regards Jeff Boyce Microsoft Office/Access MVP "stephendeloach via AccessMonster.com" u32891@uwe wrote in message news:759e0fce8476c@uwe... I have 0;-0; as teh forma so when Qty is 0 it wont show anything... When I change it to General Number or Currency is shows 0... Jeff Boyce wrote: Are you certain the underlying field is set to hold numbers other than integers? From the description, it sounds like it might need to be changed to a "currency" data type. If your format says to show whole numbers ("0;-0"), and Access is doing that, where's the problem? Take a look in Access HELP for "format"... Regards Jeff Boyce Microsoft Office/Access MVP In my form my Quantity box shows up 18 when it is really 17.5 how do I make it show 17.5? My format is 0;-0; with decimal places set to Auto.. I dont want it to show decimal places when there is none either.. example 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#5
July 24th, 2007, 03:09 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
Number - Double, Standard...
Jeff Boyce wrote: Take another look at the underlying table fields -- what data type are these? Regards Jeff Boyce Microsoft Office/Access MVP I have 0;-0; as teh forma so when Qty is 0 it wont show anything... When I change it to General Number or Currency is shows 0... [quoted text clipped - 18 lines] want it to show decimal places when there is none either.. example 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#6
July 24th, 2007, 04:10 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
OK, so the form's control has the Format 0;-0 (i.e., no decimal places).
What happens if you change the controls Format to Currency, and set Decimal Place to 2? Regards Jeff Boyce Microsoft Office/Access MVP "stephendeloach via AccessMonster.com" u32891@uwe wrote in message news:75a767a7dd792@uwe... Number - Double, Standard... Jeff Boyce wrote: Take another look at the underlying table fields -- what data type are these? Regards Jeff Boyce Microsoft Office/Access MVP I have 0;-0; as teh forma so when Qty is 0 it wont show anything... When I change it to General Number or Currency is shows 0... [quoted text clipped - 18 lines] want it to show decimal places when there is none either.. example 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#7
July 24th, 2007, 04:37 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
It changes the numbers with $ signs, i dont neend the $ to added..
Jeff Boyce wrote: OK, so the form's control has the Format 0;-0 (i.e., no decimal places). What happens if you change the controls Format to Currency, and set Decimal Place to 2? Regards Jeff Boyce Microsoft Office/Access MVP Number - Double, Standard... [quoted text clipped - 13 lines] 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#8
July 24th, 2007, 07:24 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
Did you try out any of the other formats? For example, Fixed, 2 places?
Regards Jeff Boyce Microsoft Office/Access MVP "stephendeloach via AccessMonster.com" u32891@uwe wrote in message news:75a82c3a9feaa@uwe... It changes the numbers with $ signs, i dont neend the $ to added.. Jeff Boyce wrote: OK, so the form's control has the Format 0;-0 (i.e., no decimal places). What happens if you change the controls Format to Currency, and set Decimal Place to 2? Regards Jeff Boyce Microsoft Office/Access MVP Number - Double, Standard... [quoted text clipped - 13 lines] 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#9
July 24th, 2007, 07:40 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
When i change it, it works fine but it also shows 0. I need it to show a
blank when there is a 0.. Jeff Boyce wrote: Did you try out any of the other formats? For example, Fixed, 2 places? Regards Jeff Boyce Microsoft Office/Access MVP It changes the numbers with $ signs, i dont neend the $ to added.. [quoted text clipped - 13 lines] 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
#10
July 24th, 2007, 10:13 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Decimal places..
Your original post mentioned a "form", but you've posted in a "reports"
newsgroup. I'll assume you are talking about a report definition. You could do the 0 == nothing conversion in a query you use to feed the report, or you could use the report's OnFormat event to have Access decide, for each detail record, what value to place in that textbox control. I'd probably go with the former, so that the data coming into the report is already cleaned up. Regards Jeff Boyce Microsoft Office/Access MVP "stephendeloach via AccessMonster.com" u32891@uwe wrote in message news:75a9c54d73a12@uwe... When i change it, it works fine but it also shows 0. I need it to show a blank when there is a 0.. Jeff Boyce wrote: Did you try out any of the other formats? For example, Fixed, 2 places? Regards Jeff Boyce Microsoft Office/Access MVP It changes the numbers with $ signs, i dont neend the $ to added.. [quoted text clipped - 13 lines] 18.0 Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
