Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    Bournemouth, Dorset, England
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    displaying OLE objects in a report (Access 97)

    Hello, one of my tables links to word documents as OLE objects. However when I print preview the report it will only give me a small part of the word document with no can grow/shrink properties. I tried deleting this field and linking a text box to the field name but that doesn't display any of the word document at all. The length of these will vary from 1 to 5 pages long and I need to see every bit of all of them. How can I get a report to display the entire word document it is linked to? and also not have big gaps if there are a variety of sized documents? Thank you very much

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: displaying OLE objects in a report (Access 97)

    I don't think it is possible to do what you want. You'll see at most the first page of a document. You'd be better off printing the Word documents separately.

  3. #3
    New Lounger
    Join Date
    Jan 2004
    Location
    Bournemouth, Dorset, England
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: displaying OLE objects in a report (Access 97)

    AAaaaagghhh <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> that negates the whole idea of the db! Help! is there an alternative field I could use which would take up to five pages of text? I really desparately need a way of doing this, and having the db display all required information. I would be very grateful for any workarounds or suggestions on this one.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: displaying OLE objects in a report (Access 97)

    I don't know of a way to do what you want in a report. CanGrow and CanShrink only apply to the Text Box control and to a subreport. Also see the thread starting at <post#=309783>post 309783</post#>.

    You can provide hyperlinks to Word documents from your database. You might also consider going the other way, as suggested by WendellB in the thread I referred to: build a Word document that contains all necessary information.

  5. #5
    New Lounger
    Join Date
    Jan 2004
    Location
    Bournemouth, Dorset, England
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: displaying OLE objects in a report (Access 97)

    Thank you! I will go away and read up on creating word documents from access. There will probably be another post later on how to do this! <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •