Indent text in a Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't seem to see the option of indenting text (left margin) for a combo
box in the properties list. Is there a way?
 
Hi.
I don't seem to see the option of indenting text (left margin) for a combo
box in the properties list.

There is no option to indent text in the combo box.
Is there a way?

Yes. Set the RowSource of the combo box to a query that adds spaces before
the value in the field, so that it appears that the text is indented.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
Assuming that Center Align isn't what you want: If the Row Source of your
combo box is a query, then you can modify the query so that the text is
prefaced by a space or two.

In the field area of the query designer, use the following formula:
AliasName:" "&TableName.FieldName
Here's something from one of my mdb:
Location:" "&tblFranchise.Location

I used two spaces between the quotation marks and got about a 1/8" margin,
but I suppose the 'margin' is dependant upon the font size/style.
 
How do you make this query?

'69 Camaro said:
Hi.


There is no option to indent text in the combo box.


Yes. Set the RowSource of the combo box to a query that adds spaces before
the value in the field, so that it appears that the text is indented.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
Back
Top