Trim/Format

[Guest]

I have this trim function

=Trim("Your Child Care Grant Program Payment Request for" & " " & [Month] &
" " & "has been denied. Your Cild Care Grant Payment Request was received
after the due date of" & " " & [Date suppose to be in] & ". The Child Care
Program office received your Payment Request on" & " " & [Date Received] &
".")


I would like Date Suppose to be in, and Date Received to be bold and written
out
ex. January 5, 2006

Thanks

 

[Guest]

To get the Date field in this formt, use

format([DateFieldName],"mmmm d, yyyy")

About the bold, sorry, you can't do it in the same field when other fonts
are not bold, you can put it in seperate field that conected to each other so
it will look like one field

 

[Guest]

Okay I guess I can try that. How do I do that?

To get the Date field in this formt, use

format([DateFieldName],"mmmm d, yyyy")

About the bold, sorry, you can't do it in the same field when other fonts
are not bold, you can put it in seperate field that conected to each other so
it will look like one field

--
\\// Live Long and Prosper \\//
BS"D

I have this trim function

=Trim("Your Child Care Grant Program Payment Request for" & " " & [Month] &
" " & "has been denied. Your Cild Care Grant Payment Request was received
after the due date of" & " " & [Date suppose to be in] & ". The Child Care
Program office received your Payment Request on" & " " & [Date Received] &
".")


I would like Date Suppose to be in, and Date Received to be bold and written
out
ex. January 5, 2006

Thanks

 

[Guest]

Try this link first, mybe you'll rather do that

http://www.lebans.com/Report.htm#MixBold string

--
\\// Live Long and Prosper \\//
BS"D

Okay I guess I can try that. How do I do that?

To get the Date field in this formt, use

format([DateFieldName],"mmmm d, yyyy")

About the bold, sorry, you can't do it in the same field when other fonts
are not bold, you can put it in seperate field that conected to each other so
it will look like one field

--
\\// Live Long and Prosper \\//
BS"D

I have this trim function

=Trim("Your Child Care Grant Program Payment Request for" & " " & [Month] &
" " & "has been denied. Your Cild Care Grant Payment Request was received
after the due date of" & " " & [Date suppose to be in] & ". The Child Care
Program office received your Payment Request on" & " " & [Date Received] &
".")


I would like Date Suppose to be in, and Date Received to be bold and written
out
ex. January 5, 2006

Thanks

 

[Guest]

I tried what you suggested for the date field. That did not work. The
actual fields are correct but in the actuall text box that I wrote in, it
does not come across fine.
Any more suggestions?

Okay I guess I can try that. How do I do that?

To get the Date field in this formt, use

format([DateFieldName],"mmmm d, yyyy")

About the bold, sorry, you can't do it in the same field when other fonts
are not bold, you can put it in seperate field that conected to each other so
it will look like one field

--
\\// Live Long and Prosper \\//
BS"D

I have this trim function

=Trim("Your Child Care Grant Program Payment Request for" & " " & [Month] &
" " & "has been denied. Your Cild Care Grant Payment Request was received
after the due date of" & " " & [Date suppose to be in] & ". The Child Care
Program office received your Payment Request on" & " " & [Date Received] &
".")


I would like Date Suppose to be in, and Date Received to be bold and written
out
ex. January 5, 2006

Thanks

 

[John Vinson]

I tried what you suggested for the date field. That did not work. The
actual fields are correct but in the actuall text box that I wrote in, it
does not come across fine.

How DID it come across? Please copy and paste the result and indicate
what's wrong.

John W. Vinson[MVP]