Inline graphics in text fields

[JustAnElf]

Greetings one and all,
I am in the process of creating a 'how to' knowledge database using MS Access. I would like to create an input form that has a large field capable of entering both text and graphics.



For example, the data inside Field1 would say...
How do I change the resolution of a monitor?
Step 1: Right click in the middle of the screen
<Display picture>
Step 2: Select Screen Resolution
<Display picture>
Step 3: Etc.

The total number of steps and pictures for each knowledge article would be different for each item. There could be 1 picture in the article, or there could be 50.

Sadly however, I don't see any field types that could support what I would like to do. So far I've only seen examples where the pictures and texts are separate and static. Does anyone have any suggestions about how to over come this limitation?

I'm open to using links to point to the pictures inside the text field to a remote folder. I'm even open to creating a report that takes all of the information on the input form and organizes it in a way so it looks like the example given above.

Are there any scripts, controls, or template examples I could look at? Right now I'm open to just about any worth while idea.

[Dal Jeanis]

Hmmm. Quick look and I didn't find anything for you. It sounds like you're trying to create the equivalent of a Word Document or a FrontPage document.
There is a way to make an OLE Word document, but apparently it's buggy in Access 2010.
http://social.msdn.microsoft.com/For...orum=accessdev

[June7]

Access is a lousy text editor. Would be better to create a help document in Word. Or as was originally constructed in my db, create HTML pages that can be opened by hyperlinks and build a Help search engine with something like Tipue http://freecode.com/projects/tipjse

The student intern who built the user Help reference is no longer with us and I did not find the Help facility really needed (the db isn't that complicated), so I removed the relevant code and buttons. He was one smart kid, I never would have figured it out myself.

I just reread the OP. This is not building a Help reference for the db, the db IS the Help reference. Bing: How to create knowledge base.

Look at http://try.bloomfire.com/create-know...wledge%20+base

[JustAnElf]

Thank you for the very kind suggestions. After playing with the database design, I decided to simplify it. Right now I'm using the OLE Object data type and linking the document to field. The form looks GREAT until the Word document gets long. MS Access will take the entire document and squish the preview down to the size of a postage stamp.

Is there any way to make MS access add some scroll bars to the OLE field so it does not compress the preview into very small type?

[June7]

I doubt that is possible due to nature of the OLEObject control. The Size property has 3 options (zoom, clip, stretch). No where do I see a property to activate scroll bars.