add commas to calculated value in label

G

Guest

I want to format the number that is retruned by the expression lSize/1000 in
the following code with comma separators like this 999,999,999.

I can't seem to figure out how to do this in code.

Me.Label3.Caption = "Total Size = " & lSize / 1000 & " Kilobytes"


--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003
 
J

Jeff Boyce

Take a look at the Format() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run .bat file from Access Button 3
Open Enterpirse Manager with Button 4
Determine Database Size Programatically 1
Can bookmarks be saved in the IDE? 3
Put resutls of StoredProc using Passthrough query into an Access T 1
Save Query Results as table to another Access Database 3
Open SQL Script in Query Analyzer with Button Click 1
Automate Changing Table Name in Query 5

Top