Fixed size but no decimals

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo

I have a field with: =format(FileLen([CurrentDb].[Name]);"fixed") & "
Bytes).

How expand this code with no decimals. e.g. 2.798.000 instead of
2.798.000,00. Tried various things but "no go" ;-)

Thanks for any tips!

Regards,

Harmannus
 
Try replacing the word "fixed" with "#"
Means at least one character, but no decimal places.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thanx for the response!

Works fine!


Regards,

Harmannus

Adrian Jansen said:
Try replacing the word "fixed" with "#"
Means at least one character, but no decimal places.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
Harmannus said:
Hallo

I have a field with: =format(FileLen([CurrentDb].[Name]);"fixed") & "
Bytes).

How expand this code with no decimals. e.g. 2.798.000 instead of
2.798.000,00. Tried various things but "no go" ;-)

Thanks for any tips!

Regards,

Harmannus
Click to expand...
Click to expand...
 
Back
Top