Hi.
How come combo boxes don't have margin settings like the ones found in text
box properties?
They do, but the alignment applies to the text displayed in the combo box,
not the drop down list.
Is there a way to add a little space to move the text further to the right
inside the Combo Box?
Yes, but only if one uses the "Table/Query" Row Source Type. The other Row
Source Types, "Value List," and "Field List," don't allow spaces in the
values displayed in the drop down list.
Use a query for your Row Source and in the SQL statement for the query
concatentate a space or two before each value in the field to be displayed in
the drop down list. For example:
SELECT ID, " " & Employees.LastName AS LastName
FROM Employees;
In this example, ID is the bound column, so should have no concatenation,
and LastName is the column that will be displayed one space to the right of
the left margin in the drop down list. Note the Employees.LastName syntax to
avoid a circular reference with the alias given for the resulting
concatenation string.
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.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
- - -
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. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
