Results 1 to 4 of 4

Thread: Capitals

  1. #1
    Join Date
    Jan 2011
    Posts
    83

    Unanswered: Capitals

    Hi All,

    I have a command button that generates an e-mail. My code is:

    DoCmd.SendObject , , , , , , "Quote Number: " & QuoteID, [txtQuoteDetails]

    The text string that is in me.txtQuoteDetails is all in lower case. How do I change my code to make it all Upper Case.

    Thanks.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    UCase (Me.txtQuoteDetails)
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2011
    Posts
    83
    That was too easy! I feel embarassed now.

    Thanks for your help!

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    No need to feel embarrassed! VBA is a complex language with hundreds of command and functions! I've been doing it for a dozen or more years and learn something every day!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •