Control format alignment? (1 Viewer)

Gasman · May 1, 2018

Hi all,

I have two controls on a form as format currency with a DSum as their source.
Below those I have another control that shows the difference.

If I use format Currency for the last (balance) control everything lines up, but I would like to use the format options that I have seen CJ_London mention often, that is something along the lines of

Code:

£#,##0.00[Green];(£#,##0.00)[Red]

however the alignment is then a little out.?

I've tried using £#,##0.00 and £#,##0.00[Black] for the other two fields instead of Currency, but that makes no difference.?

Is there a way to get them to align tidily please?

TIA

Minty · May 1, 2018

I think it is allowing for the brackets if negative, so try adding a space in the positive format after the final 0?

Gasman · May 1, 2018

Doh!:banghead:

Spot on Minty, thank you. I can live without the brackets, at least for now.

arnelgp · May 1, 2018

I think [red] must be inside the parenthesis.
Use same format for the two without color.
Chk the alignment to right.

isladogs · May 1, 2018

If you still want the brackets as well as the colour, have a look at this link
https://www.access-programmers.co.uk/forums/showpost.php?p=1566112&postcount=3

Or look at post #3 in the link in my signature line - it's the same thread

Gasman · May 1, 2018

Hi arnelgp,
Putiing the olour inside the bracket made no difference. The alignment is already set to right.
I've changed the other fields to

Code:

£#,##0.00

that actually has a space after the last 0 and that works, so brackets are back in.

arnelgp said:
I think [red] must be inside the parenthesis.
Use same format for the two without color.
Chk the alignment to right.

Galaxiom · May 1, 2018

Are you using a monospaced font so all characters are the same width?

Gasman · May 1, 2018

Calibri 11 ?
I just use the default that Access supplies.

isladogs · May 1, 2018

This shows a minor change to the NumberField formatting in the deliberately hideously formatted sample database I listed earlier:

The red & green entries in the NumberField look perfectly aligned to me
Blue & magenta items almost perfect

Format used for Number field is:0.00[Green] ;-(0.00)[Red];[Blue]"0 ";[Magenta]"Nothing Entered "

I'm also using the default Access font - Calibri 11pt

Gasman · May 1, 2018

I believe Minty was correct saying Access was allowing for the closing bracket.?

Using the custom format mentioned previously and not Currency for the other controls produces the image attached.

That is good enough for me.

isladogs · May 1, 2018

Gasman said:
I believe Minty was correct saying Access was allowing for the closing bracket.?

Using the custom format mentioned previously and not Currency for the other controls produces the image attached.

That is good enough for me.

Yes Minty is correct - I was trying to fix the 0 and Nothing entered as well

Galaxiom · May 2, 2018

Gasman said:
Calibri 11 ?
I just use the default that Access supplies.

Calibri is a proportional font. The characters are not a consistent width so the won't necessarily line up in columns.

Courier New is a commonly used fixed width font but there are others.

Gasman · May 2, 2018

Thanks Galaxiom, I'll mind that for the future.
The extra space is enough to line up the numbers at least.

Galaxiom said:
Calibri is a proportional font. The characters are not a consistent width so the won't necessarily line up in columns.

Courier New is a commonly used fixed width font but there are others.

Control format alignment? (1 Viewer)

Gasman

Enthusiastic Amateur

Attachments

Minty

AWF VIP

Gasman

Enthusiastic Amateur

arnelgp

..forever waiting... waiting for jellybean!

isladogs

MVP / VIP

Gasman

Enthusiastic Amateur

Galaxiom

Super Moderator

Gasman

Enthusiastic Amateur

isladogs

MVP / VIP

Attachments

Gasman

Enthusiastic Amateur

Attachments

isladogs

MVP / VIP

Galaxiom

Super Moderator

Gasman

Enthusiastic Amateur

Similar threads

Users who are viewing this thread