Results 1 to 5 of 5

Proper Case not working

Threaded View

duckboy1981 Proper Case not working 09-10-2008, 07:09 AM
Andy Pope text boxes do not have a... 09-10-2008, 07:27 AM
royUK This works for me, change the... 09-10-2008, 07:29 AM
duckboy1981 RoyUK - Works a treat thank... 09-10-2008, 08:19 AM
royUK Best stick to this forum then... 09-10-2008, 08:21 AM
  1. #1
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Somerset, England
    MS-Off Ver
    XP, 2003, 2007 - depends on location
    Posts
    185

    Proper Case not working

    Hi,

    I am trying to force the input of a text box to be changed to Proper Case (First letter of each word capitalised) but for some reason it is not working. I am using the fucntion below, can anybody see what I am doing wrong?

    Private Sub txtFirstname_LostFocus()
    
        Me.txtFirstname = StrConv(Me.txtFirstname, vbProperCase)
    
    End Sub
    Thanks,
    David
    Last edited by VBA Noob; 09-10-2008 at 08:24 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PROPER Formula Meeting With Postcode Problems
    By SamuelT in forum Excel General
    Replies: 4
    Last Post: 04-10-2008, 10:28 AM
  2. Cash Budget Question in relation to Excel
    By aceman in forum Excel General
    Replies: 2
    Last Post: 06-11-2007, 09:32 AM
  3. XIRR: Different cash flows but same answer. Why?
    By Guy Hoffman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-24-2007, 11:37 AM
  4. proper format for functions
    By DKY in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-13-2007, 08:39 AM
  5. Can I identify entries NOT done in Proper case?
    By Potoroo in forum Excel General
    Replies: 2
    Last Post: 10-12-2006, 12:42 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1