Fixed size but no decimals

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
 
A

Adrian Jansen

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
 
H

Harmannus

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...
 

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

Show database size on form? 4
Why lost decimal places in euro fields? 2
Display fixed decimal place in Access forms 3
Hide/unhide button 5
Display of numerical value with decimals in a text box 5
Field TAB color 2
Menubar 2
exporting number fields 4

Top