Results 1 to 4 of 4
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    316

    How to Set Font to Small Caps using VBA

    My client wants a company name that appears on multiple forms and reports to show as font name Garamond which is fine... however, he also want the font to appear as "Small caps". In Word and Outlook, under the Font submenu, I can check Small caps and get what he wants... lower case letters are shown as Small capital letters. Is there a way I can make the same settings on labels in Access without installing a new font on each workstation that runs the database. Thanks, Eddie

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    None that I know of.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I see an image control in your future. Perhaps you can bind an OLE object to a word doc that has the text you desire.

  4. #4
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    316
    I'm going to mark this as "solved" even though the only solution I could find was to install the "small caps" font on every workstation.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with a small query
    By Datech in forum Queries
    Replies: 4
    Last Post: 05-10-2012, 09:14 AM
  2. Convert VALUE in Textbox to CAPS in TABLE
    By taimysho0 in forum Programming
    Replies: 3
    Last Post: 12-30-2011, 05:04 PM
  3. help in small Instock inventory
    By Nokia N93 in forum Forms
    Replies: 2
    Last Post: 03-20-2011, 01:00 PM
  4. small help needed
    By arthasdk in forum Access
    Replies: 3
    Last Post: 01-07-2011, 12:08 AM
  5. small if statement help please
    By taylorosso in forum Programming
    Replies: 16
    Last Post: 09-23-2009, 11:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums