asked on

cboQuickSearch Font Size

Access 2010
I have a QuickSearch combo in the form header. When the record is found the name is shown in the header with the font being the same size as the combo drop down. What I would like is for the name to be displayed in a much larger font and style. Would I would need another header textbox to display this larger size? and the after update procedure?

Thanks

Rey Obrero (Capricorn1)

you can do it in design view of the form, however if you want to make it dynamic you can set the fontsize

me.txtbox.fontsize=16
me.txtbox.fontbold=true

zpotok

ASKER

Thanks for the reply...
If I use me.cboQuickSearch.fontsize=16
the text does increase but stays large on selecting a different record.

If I use a new textbox> me.Text22.fontsize=16 it does not get populated.

Rey Obrero (Capricorn1)

to have an unbound textbox populated

me.text22=me.cboQuickSearch
me.Text22.fontsize=16

zpotok

ASKER

capricorn1..
I really appreciate your help on this - sorry I'm not more 'saavy'.
We're almost there....Text22 is now showing ID number and not the name.
Don't know if this helps but.......RowSource for cboQuickSearch is:
SELECT tblClients.ClientID, [LastName] & ", " & [FirstName] AS Name, tblClients.[FirstName], tblClients.[LastName] FROM tblClients ORDER BY [LastName] & ", " & [FirstName];

Please let me know if I should close this out and open another question to get this resolved. Thanks

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zpotok

ASKER

Just what I was looking for.
Thanks for your time and patience.