Memo Field needs to include field name within field.

[LMW]

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?

 

[Douglas J. Steele]

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

 

[Tom van Stiphout]

On Fri, 20 Nov 2009 14:11:04 -0800, LMW

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

-Tom.
Microsoft Access MVP

 

[Douglas J. Steele]

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

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

On Fri, 20 Nov 2009 14:11:04 -0800, LMW

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

-Tom.
Microsoft Access MVP

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?

 

[Tom van Stiphout]

On Sat, 21 Nov 2009 06:51:17 -0500, "Douglas J. Steele"

Yes, that's 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

 

[LMW]

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 wouldn't be aligned.

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

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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?

.

 

[LMW]

That is correct. That was my first attempt.

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

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

On Fri, 20 Nov 2009 14:11:04 -0800, LMW

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

-Tom.
Microsoft Access MVP

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?

.

 

[LMW]

That worked great. Thank you!

On Sat, 21 Nov 2009 06:51:17 -0500, "Douglas J. Steele"

Yes, that's 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 suspect that the OP had "Note:" & " " & [Note] in the query that's used
as the report's RecordSource, and I believe that will convert the memo to
text.

.