Format right justify

[redFred]

I found Format([name],"0") to remove currency symbol.

Can anyone tell me how to right justify using format in query?

Or...can you tell me where to find Format for this issue in help or anywhere
else?

Thanking you very much,

 

[Jeff Boyce]

?Are you trying to right justify a numeric value in a query?

In a form, or in a report, you can use the left, center and right justify
toolbar buttons. But in a query? I don't believe I've run across that
before.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[redFred]

Thanks, Jeff.

I am using 2007. Of course I use the toolbar all the time.

In this case, I have a combo box with calculated numeric controls in its
recordsource -- and the columns display in the combo box as left justified.
That's fine for text, but looks really sloppy for numbers.

Got an alternative to acheive the combo column number justify?

Thanks.
--
redFred

?Are you trying to right justify a numeric value in a query?

In a form, or in a report, you can use the left, center and right justify
toolbar buttons. But in a query? I don't believe I've run across that
before.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I found Format([name],"0") to remove currency symbol.

Can anyone tell me how to right justify using format in query?

Or...can you tell me where to find Format for this issue in help or
anywhere
else?

Thanking you very much,

 

[Jeff Boyce]

There's a few approaches to consider.

First, take another look at your formatting features in Access 2007. I seem
to recall there was, in some instances, rich text formatting available.

Next, Stephen Lebans has a website on which he offers a variety of special
formatting routines.

And third, consider using a subform with individual rows ... it sorta looks
like a combobox (but doesn't act like one). The advantage is that you can
set the justification on the individual textboxes.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks, Jeff.

I am using 2007. Of course I use the toolbar all the time.

In this case, I have a combo box with calculated numeric controls in its
recordsource -- and the columns display in the combo box as left
justified.
That's fine for text, but looks really sloppy for numbers.

Got an alternative to acheive the combo column number justify?

Thanks.
--
redFred

?Are you trying to right justify a numeric value in a query?

In a form, or in a report, you can use the left, center and right justify
toolbar buttons. But in a query? I don't believe I've run across that
before.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I found Format([name],"0") to remove currency symbol.

Can anyone tell me how to right justify using format in query?

Or...can you tell me where to find Format for this issue in help or
anywhere
else?

Thanking you very much,

 

[redFred]

Thanks, Jeff. I shall try your suggestions.
--
redFred

There's a few approaches to consider.

First, take another look at your formatting features in Access 2007. I seem
to recall there was, in some instances, rich text formatting available.

Next, Stephen Lebans has a website on which he offers a variety of special
formatting routines.

And third, consider using a subform with individual rows ... it sorta looks
like a combobox (but doesn't act like one). The advantage is that you can
set the justification on the individual textboxes.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks, Jeff.

I am using 2007. Of course I use the toolbar all the time.

In this case, I have a combo box with calculated numeric controls in its
recordsource -- and the columns display in the combo box as left
justified.
That's fine for text, but looks really sloppy for numbers.

Got an alternative to acheive the combo column number justify?

Thanks.
--
redFred

?Are you trying to right justify a numeric value in a query?

In a form, or in a report, you can use the left, center and right justify
toolbar buttons. But in a query? I don't believe I've run across that
before.

Which version of Access are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I found Format([name],"0") to remove currency symbol.

Can anyone tell me how to right justify using format in query?

Or...can you tell me where to find Format for this issue in help or
anywhere
else?

Thanking you very much,

 

[John Spencer]

You might try

Val(Format([Name],"0"))

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[redFred]

Thanks, John. I tried it, but no alignment change,. It did return zero
rather than null if no value.


--
redFred

You might try

Val(Format([Name],"0"))

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

Thanks, Jeff. I shall try your suggestions.