How to uppercase a text box in a report

Posted on 2006-06-08
Last Modified: 2009-12-16
Access 2003 question.

I have an access report (rptOrder)  that gets data from a query, (qryInvoice)

There are dozen text boxes with control sources set such as


The report displays them fine.  But now I want them to appear upper case for this
report.  I do not want to change the data in the tables permenately.
However setting control sources with below efforts using function UCASE do not work, as data do not resolve.


I must not be using the proper way to point/bind the data.  

What is the proper way to do this.

Sample database is here;
Question by:luxlink
    LVL 65

    Expert Comment

    by:Jim Horn
    (Wild guess)  Try UCase() without the $.
    LVL 65

    Expert Comment

    do the UCASE$ in the query

    select UCASE$(CompanyName) AS CName

    then reference CName in the report

    try it that way
    LVL 34

    Accepted Solution

    You can set the Format option for the text boxes on your report. Use this character ">".

    Author Comment

    re; jimhorn;     without the $ has no effect.
    re; rockiroads;   yes that will work for a single field, but becuase there are so many fields to do, there is no more room in the left in the query (eg all the columns are full).


    Author Comment

    Re; Jefftwilley;   It works!    Even the microsotft help on text box->properties->format (format property) does not show ">" symbol. Excellent find.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    779 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

    12 Experts available now in Live!

    Get 1:1 Help Now