More than 255 characters in a text box.

[stgill]

I have a table with several memo fields. I need to combine these to form 1 paragraph and place this on a report.

I can combine the memo fields to form a new field, but this only creates a text field that can hold 255 characters. I need more so that I can view the whole field (more than 255 characters) on a report.

Any ideas appreciated.

Peter

 

[KenReay]

Hi

Could you show your code?

txtBox = MyMemo1 & MyMemo2 ...etc

should work

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Crowley16]

that's probably because when you're creating the new field, you're using the default datatype of text...

when you're creating the new field, set it's datatype to memo...

showing us some of your code would help

 

[stgill]

I have created a new field in the source for my report as shown below:

Final: [Preferred Name]+[Opening1]+[Opening2]+" "+[Sex]+[Self-Others]+" "+[Preferred Name]+" "+[Subject1]+" "+IIf([Subject2]<>" ",[Subject2],"")+" "+Preferred Name]+[Developmental]

All fields referenced above are set to memo. The new field will only show the first 255 characters, as does the text box on the report.

Peter

 

[Crowley16]

just thought I'd mention:
ur missing a [ off the 2nd preferred name

also, use '&' instead of '+' since ur working with strings

 

[dhookom]

I would also get rid of the IIf()
Final: [Preferred Name] & [Opening1] & [Opening2] & " " & [Sex] & [Self-Others] & " " & [Preferred Name] & " " & [Subject1] & " " & [Subject2] & " " & [Preferred Name] & [Developmental]


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[stgill]

Thanks for assisting. I got it to work. Sometimes I think my brain goes out of its way to make me look stupid.

Peter