Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Capitalize the first letter in a string

Status
Not open for further replies.
terpster

terpster

MIS
Mar 18, 2002
26
US
Was wondering if there was anything in access that would allow me to capitalize the first letter in a string? Something similar to initcap in oracle?

Many thanks!

 
Sort by date Sort by votes
Hi terpster,

Use the following

StrConv("YourStringHere",3)

That should do it

Regards,
gkprogrammer
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
819
TomSalvato
TomSalvato
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
990
Kennelbloke
Kennelbloke
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
685
PrimoSteve
PrimoSteve

Part and Inventory Search

Sponsor

Back
Top