Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Thousand seperator in custom formats

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Thousand seperator in custom formats

Resolved · Medium Priority · Version 2003

Reply Thu 18 Sep 2008, 10:14Delegate Paul said...

Paul has attended:
Access VBA course

Thousand seperator in custom formats

Hi,
I am trying to popolate KPIs into a two column list field called lstDepartmentKPIs. Each KPI may have a different format.
Whilst I know the line is picking up the custom format as it's putting brackets round negative numbers, it is not putting in the thousand seperator.
Is it something I'm doing wrong.

Me.lstDepartmentKPI.AddItem "Total Turnover" & ";" & Format(.Fields("TotalTurnover"), "

For upcoming training course dates see: Pricing & availability

Reply Fri 26 Sep 2008, 11:18Trainer Laura said...

RE: Thousand seperator in custom formats

Hi Paul

Thanks for the question and an easy one.

Don't use the *, use # instead.

I hope that solves your problem

Laura

Access articles

· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· Microsoft Access Training Opens Doors
· Get To Know The 3 As: Access Accuracy Achievement
· So You Still Haven't Learned How To Use Access Yet?
· Microsoft Access: Unleash the True Potential Today

Please browse our web site to find out more about
microsoft.access.courses and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips