Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Post Unanswered: Text Case - HELP !

    I have field containing text in all lower case, how do you display in a report or form the capitalisation of the first letter of every word.

    Is this possible ?

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Portugal
    Posts
    146
    DonaldT,

    In the reports OnFormat event type this:

    [control name]=StrConv(Me![control name], vbProperCase)

    hope this helps!

  3. #3
    Join Date
    Apr 2002
    Location
    Portugal
    Posts
    146
    Donaldt,

    My Access is in Portuguese, maybe the OnFormat event that i told you, doesn't spel like that, one thing is for shore, right click in the same place that your control is, or, for example, if the control is in the header of the report, right click there, (not on the control, but in an empty space), click on propertys and then the events tab, and the first event option is the OnFormat event.

Posting Permissions

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