How input a MEMO Type field and how include in Report

[rchristopher]

How input a MEMO Type field? Can't define variable length space in Form.
How include MEMO Type field in report. Can't define variable length space in report.

[John_G]

Textboxes are used for Memo fields just as they are for String types, in both forms and reports. They don't usually require any special coding. In reports is a good idea to set Can Grow = True so that you see all the contents.

John

[rchristopher]

Textboxes are used for Memo fields just as they are for String types, in both forms and reports. They don't usually require any special coding. In reports is a good idea to set Can Grow = True so that you see all the contents.

John

A memo field should allow a "can grow" concept in the input Form. Doesn't a Text Box require the definer to set a maximum amount of space? The user should be able to simply keep typing input and let the space grow. Is there any other way of inputting other than predefining the space in a Form?

[John_G]

The memo type refers to the type of the table field the textbox control is bound to, not to the textbox itself. Textboxes don't have types or set field lengths, so you can type as much text data as the table field will allow - for Memo fields, this is essentially unlimited.

If you will be entering a large amount of data, make the textbox fairly large on the form and add a vertical scroll bar so you can scroll up and down through the data. But in forms, textboxes do not have a CanGrow property.

"Is there any other way of inputting other than predefining the space in a Form?" No, but as I said, you don't need to, ant you cannot predefine it anyway. But you can limit how much text is entered with VBA if you need to.

HTH

John