Results 1 to 2 of 2
  1. 10-06-2015, 11:13 AM #1
    danvadis
    danvadis is offline Novice
    Windows 8 Access 2007
    Join Date
    Sep 2015
    Location
    Accra, Ghana, West Africa
    Posts
    5

    Question Using mix Case


    what do I do so that when I type into a field the first character becomes an Upper case automatically.
    Reply With Quote Reply With Quote
  2. 10-06-2015, 11:19 AM #2
    ItsMe's Avatar
    ItsMe
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    You want the StrConv() function and the argument vbProperCase
    Code:
    Dim strSample As String
strSample = Me.txtSample.Value
Me.txtSample.Value = StrConv(strSample, vbProperCase)
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Case Management - Multiple 'note' recors for each case
    By Theflow in forum Access
    Replies: 3
    Last Post: 10-27-2014, 07:37 AM
  2. Case for in case field corrupt
    By Ruegen in forum Forms
    Replies: 9
    Last Post: 08-03-2014, 07:56 PM
  3. CASE in SQL
    By alka in forum Access
    Replies: 12
    Last Post: 11-27-2013, 04:15 PM
  4. How To Change Upper Case Letters to Lower Case?
    By djclntn in forum Queries
    Replies: 5
    Last Post: 10-23-2012, 03:55 PM
  5. Case when
    By krufruf in forum Queries
    Replies: 2
    Last Post: 07-20-2012, 03:59 PM

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