Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Ms Access


  • Please log in to reply
2 replies to this topic

#1 Tanmuz

Tanmuz

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:11:15 AM

Posted 06 September 2008 - 12:05 AM

Hi, I am creating a database using MS access 2003. What I need to do is change the first letter of a name field to Uppercase so when the data is entered it reflects an UPPERCASE in the table.
Can this be done and how?

...Example: Change bill to Bill...

Regards :thumbsup:

Edited by Tanmuz, 06 September 2008 - 12:23 AM.

Tanmuz (Cattas)

BC AdBot (Login to Remove)

 


#2 Billy O'Neal

Billy O'Neal

    Visual C++ STL Maintainer


  • Malware Response Team
  • 12,304 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Redmond, Washington
  • Local time:06:15 PM

Posted 06 September 2008 - 12:51 AM

Hello, Tanmuz.

Not sure for access specificly, but I think you can setup some sort of a data.onchanged event in Visual Basic for Applicaitons and do something like:
Dim data as string 'This is what I'm using as a placeholder
return UCase(Left(data,1)) + LCase(Right(data, StrLen(data)-1))

Convert the leftmost character to uppercase, and convert the rest of the characters (Which is the length of the start string minus the first letter we capitalized) to lowercase.

Not sure EXACTLY how to add that code in access, but that logic will work.

If on the other hand you want to preserve the case of the rest of the letters, remove the LCase function call and respective end ) :thumbsup:

Billy3
Twitter - My statements do not establish the official position of Microsoft Corporation, and are my own personal opinion. (But you already knew that, right?)
Posted Image

#3 Tanmuz

Tanmuz
  • Topic Starter

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:11:15 AM

Posted 06 September 2008 - 01:00 AM

Thanks Billy but that seems a little complicated for myself.
Amazing that I used your name as an example...
Regards

:thumbsup:
Tanmuz (Cattas)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users