Fomrat Number on Datasheet (1 Viewer)

Snowflake68 · Jan 25, 2019

I have a number field and that I want to display zeros on a datasheet form but also show the commas for the thousands. Eg. 2,500
I formatted the text box on the datasheet form to #,### but this doesnt show the zeros. How do I format it so that also show the zeros.

row 1 value = 2,500
row 2 value = 0

row 1 shows correctly but row 2 shows nothing

pbaldy · Jan 25, 2019

So it only shows 25? That would be really odd. If the value is 2500 and it's not formatting with the comma, my guess is the value is seen as text rather than a number. Either change the data type of the field or look for something along the way changing how it's seen (Format function, IIf maybe, etc).

MajP · Jan 25, 2019

(0) Digit placeholder. Display a digit or a zero. If the expression has a digit in the position where the 0 appears in the format string, display it; otherwise, display a zero in that position.If the number has fewer digits than there are zeros (on either side of the decimal) in the format expression, display leading or trailing zeros. If the number has more digits to the right of the decimal separator than there are zeros to the right of the decimal separator in the format expression, round the number to as many decimal places as there are zeros. If the number has more digits to the left of the decimal separator than there are zeros to the left of the decimal separator in the format expression, display the extra digits without modification.

(#) Digit placeholder. Display a digit or nothing. If the expression has a digit in the position where the # appears in the format string, display it; otherwise, display nothing in that position. This symbol works like the 0 digit placeholder, except that leading and trailing zeros aren't displayed if the number has the same or fewer digits than there are # characters on either side of the decimal separator in the format expression.

CJ_London · Jan 25, 2019

have your tried

#,###.00

pbaldy · Jan 25, 2019

Oh, were the decimals the problem? I went off in the wrong direction then.

CJ_London · Jan 25, 2019

maybe, maybe not, post could be interpreted in a number of ways.

Snowflake68 · Jan 25, 2019

pbaldy said:
So it only shows 25? That would be really odd. If the value is 2500 and it's not formatting with the comma, my guess is the value is seen as text rather than a number. Either change the data type of the field or look for something along the way changing how it's seen (Format function, IIf maybe, etc).

no it does show 2,500 correctly, the issue is that I still want to display single 0 values too but when the value is just 0 it doesnt display anything just looks like an empty value.

Snowflake68 · Jan 25, 2019

I've sorted it now just formatted it to #,##0 and this works perfectly.

Thanks everyone for trying to help

pbaldy · Jan 25, 2019

Is the value 0 or is there nothing there? You can try this

#,##0

Snowflake68 · Jan 25, 2019

pbaldy said:
Is the value 0 or is there nothing there? You can try this

#,##0

Thank you, I got there in the end

CJ_London · Jan 25, 2019

so we all had a different interpretation, all of them wrong:banghead: goes to show the benefit of providing before and after examples as per the modified first post

pbaldy · Jan 25, 2019

Ah yes, the edited post is clearer, and I was certainly on the wrong track. Glad you got it working.

Snowflake68 · Jan 28, 2019

pbaldy said:
Ah yes, the edited post is clearer, and I was certainly on the wrong track. Glad you got it working.

Yes apologies for not providing a clear enough example from the outset, hence edited post.

Fomrat Number on Datasheet (1 Viewer)

Snowflake68

Registered User.

pbaldy

Wino Moderator

MajP

You've got your good things, and you've got mine.

CJ_London

Super Moderator

pbaldy

Wino Moderator

CJ_London

Super Moderator

Snowflake68

Registered User.

Snowflake68

Registered User.

pbaldy

Wino Moderator

Snowflake68

Registered User.

CJ_London

Super Moderator

pbaldy

Wino Moderator

Snowflake68

Registered User.

Similar threads

Users who are viewing this thread