Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Force Proper Case in datasheet (Access 2000)

    I do miss the search ability here because I know I've asked this before and I can't find it in hardcopy anywhere within my files...how do you force Proper Case in an Access Table?
    Thanks so much from this repeat offender...
    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Force Proper Case in datasheet (Access 2000)

    You don't.

    You can do this on a form, not in a table. In the Before Update event of the form, you can use something like this:

    Me.txtLastName = StrConv(Me.txtLastName, vbProperCase)

    If you prefer, you can do this in the After Update event of the control (txtLastName in the example) instead of in the Before Update event of the form.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Force Proper Case in datasheet (Access 2000)

    Thank you Hans...
    Duly noted and stored away in my access files this time...no more losing this data again.
    Nannette...Going home here...looking forward to our Thanksgiving Holiday weekend...much needed rest... <img src=/S/cloud9.gif border=0 alt=cloud9 width=25 height=23>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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