Formatting a number field within a text box

I have a number of occassions to place a database field inside a bunch of
hardcoded text. But, it seems I can't do this if I want to format the number
(or field). Below is an example.
Your score this <DB Field1> is <DB Field2>%.
For DB Field1, the database stores a date/time format (6/1/2004 12:00:00AM).
I want to format it so it says June 2004. This is no problem, until I put
the field in an expression.
For DB Field2, the database stores the number as 69.15 (as an example). I
need 69.2. I can do this with no problem - as long as I don't try to put it
in an expression.
Is this normal behavior and is there any way around it?
Thanks
LeighEnter the following in the cell\textbox.
="Your score on " & Format(Fields!DBFiel1,"Y") & " was " &
Format(Fields!DBField2,"N1") & "%"
"Leigh" wrote:
> I have a number of occassions to place a database field inside a bunch of
> hardcoded text. But, it seems I can't do this if I want to format the number
> (or field). Below is an example.
> Your score this <DB Field1> is <DB Field2>%.
> For DB Field1, the database stores a date/time format (6/1/2004 12:00:00AM).
> I want to format it so it says June 2004. This is no problem, until I put
> the field in an expression.
> For DB Field2, the database stores the number as 69.15 (as an example). I
> need 69.2. I can do this with no problem - as long as I don't try to put it
> in an expression.
> Is this normal behavior and is there any way around it?
> Thanks
> Leigh