Memo Field needs to include field name within field.

I need to add a memo field into a report and I need to have the data preceded
by Note:.  I used the expression "Note:"&"  "&[Note] and now it appears I
have a text field not a memo field.  What is the best fix for this?

Can you not just have a label on the report that says Note:?

Can you not just have a label on the report that says Note:?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Works fine for me, with a few changes:="Note:" & " " & [Note]I am sure it

Works fine for me, with a few changes:
="Note:" & "  " & [Note]
I am sure it will for you too.

-Tom.
Microsoft Access MVP

I suspect that the OP had "Note:" & " " & [Note] in the query that is usedas

I suspect that the OP had "Note:" & "  " & [Note] in the query that is used
as the report's RecordSource, and I believe that will convert the memo to
text.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

Yes, that is possible.

Yes, that is possible. I did mine as an expression in the ControlSource
of the control on the report, and I did get the full memo text, not
just the first 255 chars.

-Tom.
Microsoft Access MVP

I need the field to expand and I have another field right below it.

I need the field to expand and I have another field right below it.  If I
leave the label on the report the first field could expand and the second
label would not be aligned.

That is correct. That was my first attempt."Douglas J. Steele" wrote:

That is correct.   That was my first attempt.

That worked great. Thank you!"Tom van Stiphout" wrote:

That worked great.  Thank you!