Changing case

[Gaylord]

Hi,

I have a question that is probably very easy to do, but I can't think how.

I populate my database using OCR technologies, which converts all the characters to upper case. Which I am happy with from a data storage point of view, however, when I am generating letters using Reports, having "Dear JAMIE" looks pretty informal and untidy. I don't know if there is a simple format I can use on the form, or a loop I can perform through the DB that will convert everything into title case????

Thanks in advance,

Jamie

 

[PaulBricker]

You could use the StrConv() function. If [FirstName] = "JAMIE" then
"Dear " & StrConv([FirstName], vbProperCase)
will return

Dear Jamie

See if that helps.

Paul

 

[jdegeorge]

Check out this thread... thread181-7043

Jim DeGeorge