Hi,

I have what I feel is a very simple issue with a Datasheet that is opened in a subform from a Query.

The issue is that whatever the field is set to in the original table design view, either as a text field or a memo field, I cannot get the field to wrap. Therefore the data just scrolls off the edge of the page.

Please let me know what I am missing? Is it that the fields cannot be set to wrap? I have very little hair as it is now and it is getting less every time I look at this problem.

There should be a wrap text or text wrap property for the text box. You may have to set Can Grow to true as well.

Hope that helps - if not, yell!!

Mike

Mike
EchoVue.com

Can't find the text wrap facility and the text box has been set to can grow. However I am not interested in seeing a form with text boxes, I need to see the Query/Table on a Form in Datasheet format and it is these fields that I cannot appear to control and when there is a large amount of data in one field it becomes very messy and difficult to read.

I think I am going to shave my head, that way I will not be able to pull any more hair out.

Hmmmm! I'll have to check some of the apps I have worked on in the past and try a few things.

Anyone else have more experience with forms in datasheet view?

Mike

Mike
EchoVue.com

Thanks for your suggestions. The solution was to have the data displayed in a form set to continuous forms and then arrange the text boxes to look like a datasheet. All field headers were put in the Header of teh form.