I have a form with one field. When I print (or print preview) the form, the texbox grows to show all the text. But when I place the form into a master form, so that it becomes a sub-form. the textbox does not grow. I have checked all of the settings for both master and subform, and all are set to grow. Any help will be much appreciated.

(IMG:style_emoticons/default/welcome2UA.gif)

what version of access are you using? knowing this will be able to help us give a better answer.

I am not sure what you mean by grow?

are you running a query and returning the results to this field? what type of field? textbox? combobox?

The native Access Cangrow property only applies to Reports or Forms, as you've found out, when printed.

I've never used it, but Stephen Lebans has a hack that gives controls on
Forms CanGrow functionality. You can download it from here:

http://www.lebans.com/cangrow.htm

Linq ;0)>

THanks for your quick reply. Sorry, I completely forgot to advise version - I am using ACCESS 2010.
The field is a text box. It is based on a query.
I want it to expand vertically when the text exceeds one line so that all the text shows when the user prints the form.
The textbox does expand when I print the form by itself, but when I place it inside its master form, so that it becomes a subform, the textbox no longer expands. The cangrow items on both master and subform have been set to Yes.
Ultimately, there will be more than one subform on the master form; but I figure that I had better get one working properly before adding the rest.

I think I may have replied to my own post by mistake, so I am sending it again so that my reply is to Bob's message - hopefully this won't confuse the system with a double-up.

Bob, Thanks for your quick reply. Sorry, I completely forgot to advise version - I am using ACCESS 2010.
The field is a text box. It is based on a query.
I want it to expand vertically when the text exceeds one line so that all the text shows when the user prints the form.
The textbox does expand when I print the form by itself, but when I place it inside its master form, so that it becomes a subform, the textbox no longer expands. The cangrow items on both master and subform have been set to Yes.
Ultimately, there will be more than one subform on the master form; but I figure that I had better get one working properly before adding the rest.

Thanks for your suggestion. Stephen Lebans' CANGROW is designed to enable textboxes to grow in form view, which Access alone cannot provide, whereas I want the textbox to expand while printing. THere is another
hack on the Lebans site which apears to offer what I am after: 'AutoSizeTextBox'. Unfortuantely, I can't figure out how to adpat the code to work with my form. Does anyone know of a source of information that may provide guidance?

The salient point here, really, is that Forms are not intended to be printed! All printing really shoud be done using Reports, which offer much more flexibility when printing. You'll never get what you want printing Forms, especially where Subforms are involved.

Linq ;0)>