Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 17th, 2005, 04:18 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 1,525
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to crmpicco Send a message via AIM to crmpicco Send a message via MSN to crmpicco Send a message via Yahoo to crmpicco
Default first character as Upper Case

How can i make every word inside a cell have its first character as Upper Case?

e.g.
BD Add-ons rules

changes to

BD Add-ons Rules

TIA>

Picco

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt
__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk
 
Old May 30th, 2005, 01:14 PM
Registered User
 
Join Date: May 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you are not new at programming, and you think about it for a while you will find out the answer. It is very simple problem.

Greeting, Pedro.

 
Old May 31st, 2005, 12:29 PM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

Hey Pedro: What is the point of your posting? If you don't have something to add, you shouldn't add something...
 
Old May 31st, 2005, 03:42 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 627
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Brian,
this is what Mr.Zorro wrote in another thread:

"PD.: If you don´t know the answer, please do not type nonsense."

isn't that lovely?

To cmrpicco:

which "cell" are you refering to? Take a look at the StrConv function (used with the vbProperCase setting) and see if that helps

Marco
 
Old July 1st, 2005, 01:35 PM
Authorized User
 
Join Date: May 2005
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Default

the guy that says you should post somthing useful doesnt even pst somthing useful LOL! But yes marcostraf's way would be the way to go i belive.
E.X.
    Dim str as string
    str = "BLAH"
    str = StrConv(str,vbpropercase)

hope that helps you are even still wondering :)

~~~~~~~~~~~~~~~~~~~~~
I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter. I'm sorry for having a rude signature Peter.





Similar Threads
Thread Thread Starter Forum Replies Last Post
xsl:output with encoding and UPPER case entity ROCXY XSLT 1 April 19th, 2007 08:20 AM
search string either Upper case or lower case rylemer Beginning VB 6 3 March 24th, 2004 04:23 PM
Checking for upper,lower case, number and symbol dumbdumb SQL Server 2000 1 March 18th, 2004 03:51 AM
Checking for upper case in input parameter dumbdumb SQL Server 2000 2 March 17th, 2004 03:36 AM
Check Case in a Case-Insensitive DB nbryson SQL Language 1 January 23rd, 2004 07:36 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.