Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the following to format the value that displays in a string:

Text1 = "I'll offer you " & Format(Round(Text_Offer1, 0), "#,###")

I want the value to round up to the nearest thousands

If the value was 65,548 I would want it to show 66,000

I cannot figure out how to make it work - it also has to show the comma
which it does do now
 
try this:

format([field],"#,##0,") * 1000

when the format code ends in a comma, it divides by a
thousand -- two commas, divide by a million, etc


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
It rounds fine but it does not have the comma - it shows 16000 instead of
16,000

strive4peace said:
try this:

format([field],"#,##0,") * 1000

when the format code ends in a comma, it divides by a
thousand -- two commas, divide by a million, etc


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com


I am using the following to format the value that displays in a string:

Text1 = "I'll offer you " & Format(Round(Text_Offer1, 0), "#,###")

I want the value to round up to the nearest thousands

If the value was 65,548 I would want it to show 66,000

I cannot figure out how to make it work - it also has to show the comma
which it does do now
Click to expand...
Click to expand...
 
try this:

format(clng(nz([field])/1000) * 1000,"#,##0")

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com


It rounds fine but it does not have the comma - it shows 16000 instead of
16,000

:

try this:

format([field],"#,##0,") * 1000

when the format code ends in a comma, it divides by a
thousand -- two commas, divide by a million, etc


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com


I am using the following to format the value that displays in a string:

Text1 = "I'll offer you " & Format(Round(Text_Offer1, 0), "#,###")

I want the value to round up to the nearest thousands

If the value was 65,548 I would want it to show 66,000

I cannot figure out how to make it work - it also has to show the comma
which it does do now
Click to expand...
Click to expand...
Click to expand...
 
Excellent - thanks

strive4peace said:
try this:

format(clng(nz([field])/1000) * 1000,"#,##0")

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com


It rounds fine but it does not have the comma - it shows 16000 instead of
16,000

:

try this:

format([field],"#,##0,") * 1000

when the format code ends in a comma, it divides by a
thousand -- two commas, divide by a million, etc


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com



tiredoftrying wrote:

I am using the following to format the value that displays in a string:

Text1 = "I'll offer you " & Format(Round(Text_Offer1, 0), "#,###")

I want the value to round up to the nearest thousands

If the value was 65,548 I would want it to show 66,000

I cannot figure out how to make it work - it also has to show the comma
which it does do now
Click to expand...
Click to expand...
Click to expand...
 
you're welcome ;) happy to help

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com

Excellent - thanks

:

try this:

format(clng(nz([field])/1000) * 1000,"#,##0")

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com


It rounds fine but it does not have the comma - it shows 16000 instead of
16,000

:



try this:

format([field],"#,##0,") * 1000

when the format code ends in a comma, it divides by a
thousand -- two commas, divide by a million, etc


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com



tiredoftrying wrote:


I am using the following to format the value that displays in a string:

Text1 = "I'll offer you " & Format(Round(Text_Offer1, 0), "#,###")

I want the value to round up to the nearest thousands

If the value was 65,548 I would want it to show 66,000

I cannot figure out how to make it work - it also has to show the comma
which it does do now
Click to expand...
Click to expand...
Click to expand...
 
Back
Top