var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Reporting in Sentance Case Format
I currently have an access report that reports on comments made in the case that they were typed in.
I know that in the Format property if I type > then it will report in UPPERCASE, whilst < will report in lowercase, but is there any way that I can report in sentance case... I.e. First letter of the string is UPPERCASE whilst the rest is lower.
You might could use one of the string functions such as Left() to get the first letter in a line, then you could apply the case formatting to just that letter.
Yeah, I thought that would be possible to but so far I have been unable get that to work.
The problem is that the place you input the format (see attached) doesn't allow you to build an expression and I don't know enough to write the format in VB.
Thanks for your suggestion though.
Last edited by christyxo; 07-27-04 at
Reason: Forgot attachment
Try this out.. Let me know if you have problems figuring out where to put the code:
Dim myStr As String
Dim myStrCase As String
Dim myStrLetter As String
Dim myStrRest As String
Dim myStrLength As Integer
myStr = Me.mytext
myStrLength = Len(myStr)
myStrLetter = UCase(Left(myStr, 1))
myStrRest = Right(myStr, myStrLength - 1)
myStrCase = myStrLetter & myStrRest
'The msgbox's below just demonstrate the process as it happened
'You would need to use your own code to populate a text box
Needing your help again. Where do I put this code?