Text resize

[Stew]

Just a quick question today. Does access have a option that is simliar to Excel Fit to Cell option. I am trying to format a report I have my database generating and would like to set one of the fields to have the shrink to fix the text box. I'm currently under the impression that I can't do this, however I thought I would ask the experts.

[HansV]

Access doesn't have a "shrink to fit" property for text boxes.

However, text boxes do have a Can Shrink and Can Grow property; if you set these to Yes, you should also do the same for the section that contains the text box. The height of the text box will then be adjusted automatically during print preview and print to accomodate the text.

[Stew]

Thanks Hans, that does the trick. As always your wealth of knowledge never ceases to astound.