Format right justify

  • Thread starter Thread starter redFred
  • Start date Start date
R

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,
 
?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
 
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


Jeff Boyce said:
?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 said:
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,
Click to expand...
Click to expand...
 
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


redFred said:
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


Jeff Boyce said:
?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 said:
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,
Click to expand...
Click to expand...
Click to expand...
 
Thanks, Jeff. I shall try your suggestions.
--
redFred


Jeff Boyce said:
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


redFred said:
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


Jeff Boyce said:
?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,
Click to expand...
Click to expand...
Click to expand...
 
You might try

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

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Thanks, John. I tried it, but no alignment change,. It did return zero
rather than null if no value.


--
redFred


John Spencer said:
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.
Click to expand...
Click to expand...
 
Back
Top