RE: [MS_AccessPros] Format General Number

You just test a few different formats until you find the one you want. That's how most of us learn.

Duane

To: MS_Access_Professionals@yahoogroups.com
From: robinski@mymail.net.au
Date: Sat, 8 Oct 2011 08:53:20 +1100
Subject: RE: [MS_AccessPros] Format General Number

Thanks Duane,

That was the answer. I was unaware of the use of 'Standard'. I had
always used 'General Number'. Another step learned.

Cheers,

Robin

At 8/10/2011 08:22 AM, you wrote:

>Why not just set the Format property to Standard with 0 decimal
>places. Don't do anything with the control source or anything in the
>record source query.
>
>
>
>Duane Hookom
>
>MS Access MVP
>
>________________________________
> > From: robinski@mymail.net.au
> >
> >
> > I have a report that produces totals as 123456 . I would prefer that
> > a comma were used to separate the figures. 123,456
> >
> > My attempt has failed: Format$([SumOfVisitors,"###"", ""###")
> >
> > What have I missed?
> >
> > Many thanks,
> >
> > Robin Chapple
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/