Memo Fields Jumping around when trying to put data in

  • Thread starter Thread starter Tami Kreamer
  • Start date Start date
T

Tami Kreamer

Have designed electronic manual for a nursing home there is a lot of data at
times to be put in a memo field. When the data entry person goes to type in
the data they would like the ability to Centre or Bold or insert Pictures or
graphs. The memo field does not allow this. I have tried to embed a Word
OLE File however I then run into printing problems and it really isn't that
user friendly. Is there any other alternatives I have overlooked?

Your help would be greatly appreciated.

Thanks
 
Tami said:
Have designed electronic manual for a nursing home there is a lot of
data at times to be put in a memo field. When the data entry person
goes to type in the data they would like the ability to Centre or
Bold or insert Pictures or graphs. The memo field does not allow
this. I have tried to embed a Word OLE File however I then run into
printing problems and it really isn't that user friendly. Is there
any other alternatives I have overlooked?
Your help would be greatly appreciated.

Thanks
Click to expand...

How about using a link to the Word file?
 
Hi Tami,

To add a little to Joseph's reply, ie. "How about using a link to the Word
file?", my recommendation is that you do not attempt to use OLE Object
datatype for embedding any objects via the user interface. The reason is that
your database will suffer severe bloat. If this capability is important to
you, then you might want to try an Access add-in known as DBPix from Ammara,
however, now that I take another look at this product, I'm thinking it is
only good for image files. That's a question you could ask of the vendor
before making a purchase decision:

http://www.ammara.com/articles/imagesaccess.html#OLEISSUES

To get formatting capabilities, like center, bold, italics, etc., you need
to use a rich-text control. Two possibilities come to mind--one is a free
solution offered by Stephen Lebans:
http://www.lebans.com/richtext.htm

The other one is a commercial product offered by FMS:
http://www.fmsinc.com/products/memo/index.html


I only have experience using the FMS solution. I haven't attempted to use
Stephen's control, simply because I already had Total Access Enterprise at
the time, which included Total Access Memo.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Have designed electronic manual for a nursing home there is a lot of data at
times to be put in a memo field. When the data entry person goes to type in
the data they would like the ability to Centre or Bold or insert Pictures or
graphs. The memo field does not allow this. I have tried to embed a Word
OLE File however I then run into printing problems and it really isn't that
user friendly. Is there any other alternatives I have overlooked?

Your help would be greatly appreciated.

Thanks
 
Thanks Joseph:

Let me explain in more detail my scenerio:

Lets use the example of a song.

The form would contain the fields for artist, song type, year written, etc.
etc. etc. then in the memo field would be the words to the song. However
the song is 10 pages long and I want the chorus to be centered and in the
color red. I also want to include in this memo field a picture of a guitar.
If I centre it centers everything if I change color it changes everything
and it won't let me add a picture at all.

Does this make my situation clearer?

If I use a link to the Word file I run into a multiple page printing issue.
There are many other fields on the form for input not just the memo field
and by using the memo field for procedure data entry the form knows that
when printing it is printing 1 or 10 pages of 1 of 5 pages etc. I am sure
with linking to Word it will not print the information as one document or am
I incorrect in that assumption?

Is there a way of bringing my access database into Word or excel and having
it look and work the same?

Your help always appreciated.

Tami
 
Tami said:
Thanks Joseph:

Let me explain in more detail my scenerio:

Lets use the example of a song.

The form would contain the fields for artist, song type, year
written, etc. etc. etc. then in the memo field would be the words to
the song. However the song is 10 pages long and I want the chorus to
be centered and in the color red. I also want to include in this
memo field a picture of a guitar. If I centre it centers everything
if I change color it changes everything and it won't let me add a
picture at all.
Does this make my situation clearer?

If I use a link to the Word file I run into a multiple page printing
issue. There are many other fields on the form for input not just the
memo field and by using the memo field for procedure data entry the
form knows that when printing it is printing 1 or 10 pages of 1 of 5
pages etc. I am sure with linking to Word it will not print the
information as one document or am I incorrect in that assumption?

Is there a way of bringing my access database into Word or excel and
having it look and work the same?

Your help always appreciated.

Tami
Click to expand...

I can't think of a simple one step process, although you could do it via
VBA to run the multi-steeps The best I can think of is make it a two step
process, printing a report AND printing the word document.
 
Back
Top