How to Display Memo Data Type Field Information in TextBox

[arulmani_m]

Hi,

I have bound the column that is declared as memo data type to a textbox.

The problem iam facing is the text box does not shows the character more than 255.

To be more clear the column in the access database contains more than 255 characters. but only 255 characters are displayed in the text box.

i am using access 2000.

what i have to do to display more than 255 characters in the textbox..

i have also tryed by providing Yes in CanGrow property. but it does not solve my problem.

Thanks in Advance.

M.ArulMani.

 

[lala]

make it a MEMO, not text

 

[missinglinq]

It is a Memo datatype!

CanGrow only affects forms if they're being printed, which they never should be! Printing should always be done thru a form.

Apparently your form is based on a query, and a number of things in a query can truncate a memo field. Allen Browne explains these things here and gives workarounds as well.

http://allenbrowne.com/ser-63.html

 

[lala]

you mean printing should only be done through a report?

yes, i see now, it is a memo, i saw 255 and didn't read anything else
sorry

 

[missinglinq]

Yes. Printing should really only be done thru a report. Even if all you do is right click on the form's name, click on Save As and then save it as a report. Gives you much more control over how it's arranged and printed.

I've occasionally printed a form out, but only if it's a very simple form with everything on one screen; no tabbed pages, subforms or comboboxes.

 

[arulmani_m]

hi all,

i am working in a form not in report.

what i have done is in the combo row source i have provided the below query

SELECT [Sources of Records].[Source of Records - Entity Name], [Sources of Records].[Source of Records - Location of Billing Records], [Sources of Records].[Source of Records - Mailing Address], Trim([Source of Records - City] & " " & [Source of Records - State] & " " & [Source of Records - Zip Code]) AS CSZ, Trim([Source of Records - Area Code] & " " & [Source of Records - Phone Number]) AS Phone, Trim([Source of Records - Area Code] & " " & [Source of Records - Facsimile Number]) AS FAX, [Sources of Records].[Source of Records - Amount of Prepayment Required], [Sources of Records].[Source of Records - Miscellaneous Notes], [Sources of Records].[Source of Records - Speciality - Primary], [Sources of Records].Number, Trim([Source of Records - Area Code] & Replace([Source of Records - Facsimile Number],"-","") & "@mhsfax.com") AS Facsimile
FROM [Sources of Records]
ORDER BY [Sources of Records].[Source of Records - Entity Name];

and in the textbox control source i have provided as =[cboSOR].[column](7).

cboSOR.[column](7) refers to [Source of Records - Miscellaneous Notes]. this field is declared as memo type in the table.

the probelm that i am facing is if the [Source of Records - Miscellaneous Notes] column contains more than 255 characters, only 255 characters are displayed in the textbox, the remaining characters are not displayed in the text box.

if any one provide me solution to ovwercome this issue this will be usefull for me.

Thanks

M.ArulMani

 

[missinglinq]

Have you looked at the link I gave you above for Allen Browne's article on this problem? It's quite comprehensive.