cboQuickSearch Font Size

Posted on 2011-04-24
Last Modified: 2013-11-28
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?

Question by:zpotok
    LVL 119

    Expert Comment

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


    Author Comment

    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.  
    LVL 119

    Expert Comment

    by:Rey Obrero
    to have an unbound textbox populated


    Author Comment

    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
    LVL 119

    Accepted Solution

    if you want to show the name


    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now