General discussion

Locked

OLE Field in a MS Access Report

By Tino2001 ·
Is there a way to place the OLE field in a Access report and have the field grow as needed to present a Word document?
I have been able to create the table to hold the field and the form to create the field, but it seems impossible to present thefield in a report just like the filed would look as the document itself. I have tried changing the size property but this does not seem to work. Any sugestion will be greatly appreciated.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

OLE Field in a MS Access Report

by bpulliam In reply to OLE Field in a MS Access ...

I've never tried this before, and i'm not sure exactly what your trying to do.

I'll try to help anyways. There is a property setting for each field on a report called:

Can Grow yes/no
Can Shrink Yes/no

Try setting Can Grow to Yes.

I use it to keep text fields from getting cut on remark type fields when I don't know how many characters to expect.

I'm not sure what version of Access your using but you should know that doing the above plays havoc with any boxes or lines you may have drawn on the report itself in Access 97. The lines don't seem to adjust with the rest of the document.

hope this helps.

Collapse -

OLE Field in a MS Access Report

by Tino2001 In reply to OLE Field in a MS Access ...

The question was auto-closed by TechRepublic

Collapse -

OLE Field in a MS Access Report

by heather In reply to OLE Field in a MS Access ...

If a report has OLE objects that are Empty or Null, you can set up a report so that Empty or Null OLE objects do not appear.

For step by step instructions of how to do this go to:

http://support.microsoft.com/support/kb/articles/Q210/5/99.ASP

Collapse -

OLE Field in a MS Access Report

by Tino2001 In reply to OLE Field in a MS Access ...

The question was auto-closed by TechRepublic

Collapse -

OLE Field in a MS Access Report

by Tino2001 In reply to OLE Field in a MS Access ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums