Resize text fields and print current page

[cadmaster]

Hi everyone,
I need help on how to either resize the text field or split the text field.
Whenever I print out the current page, the MS access only print out the whole data (in other word, it prints out all the pages that belongs to the file.)

Could someone please help me with those 2 issues?

[June7]

You have to filter the form recordset so only the record you want is available to print.

However, reports are intended to be printing objects, not forms. Textboxes on report will grow to handle the content.

[cadmaster]

Hi Super Moderator
I tried to insert this this form onto report and also tried to printed it out. It printed all the pages from the forms.

I am just a MS access beginner. Do you know how to make those text boxes resize directly on the form?
thanks

[June7]

No, forms are not made to work that way, textboxes do not shrink or grow. Do not put form on report, build a report that has the same RecordSource as the form. Create textboxes on the report. Bind textboxes to fields. Access Help has guidelines on building reports.

Open the report with filter criteria. Here is one method: http://datapigtechnologies.com/flash...mtoreport.html

And another (the one I prefer):
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
http://www.blueclaw-db.com/docmd_openreport.htm