Database Discussion - Auto Captial Letter at start

Print Page | Close Window

Auto Captial Letter at start

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17067
Printed Date: 28 March 2026 at 9:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Auto Captial Letter at start

Posted By: pjb007
Subject: Auto Captial Letter at start
Date Posted: 29 October 2005 at 11:16am

I have made a simple database for a forum I am a member of.

Is there some code I can add that will make the first letter of a record a captial letter (just the first letter of the first word).

DB: Access 2003, using ASP pages.

Replies:

Posted By: Mart
Date Posted: 29 October 2005 at 1:14pm

Response.Write UCase(Left(rs("whatever"), 1))
Response.Write Right(rs("whatever"), Len(rs("whatever")) - 1)

Haven't used VBScript for a year or 2 so it might not work