Results 1 to 2 of 2
  1. 01-29-2010, 12:03 PM #1
    access2010
    access2010 is offline Novice
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jan 2010
    Posts
    1

    Ucase

    Hi all, new to the forum, have worked with access for a number of year, but not in the last 6 yrs. I down loaded MS office 2010 beta. Nice package. OK now for my problem. I create a report (grouping header) using =UCase(Left(Nz([author]),1)), It works perfect and looks great. On the next report I used the same (=UCase(Left(Nz([author]),1))) it works but repeats the first letter for each record. I can't figure out what I am missing or doing wrong. Compared properties. Help. Thanks in advance
    Reply With Quote Reply With Quote
  2. 01-29-2010, 06:21 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    On the Format tab of the property sheet for the Control involved way down at the bottom of the list is "Hide Duplicates". Is that what you were looking for?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums