How to Columnate Memo on Report

[doyle60]

I have a report, a Purchase Order, with header and a few detail subs,
that works just fine. But we want to add a large memo to it at the
bottom. It would be best if the memo prints out in columns beneath
the report. The memo could be as many as three or four columns on a
legal piece of paper oriented in landscape.

If I do not columnate this large memo, the report becomes a bit
ungainly, ugly, and that just ain't me.

Of course, my subform for this memo does columnate. But when I print
preview the main form, it is not columnated.

Has anyone had this problem and worked around it successfully? Is
there a way to count lines and create four controls for each section?
I asked a similar question a few months ago and solved it but that was
to columnate data, record lines. This is a memo and so without any
set number of lines.

Thanks,

Matt

 

[Kardan via AccessMonster.com]

Hi Matt

If you are talking about a memo field, there is very liitle you can do with
that as it is exactly what it says on the tin, i.e a 'memo' and not 'real
data'.

If you want to use this information then use text fields that you can work
with.

If you really think that the contents have been entered in such a way that
they should display in columns, check the font you are using and make sure it
is not a proportional spacing font. Generally fonts that are not PS are not
so pretty, such as Courier. Try it with Courier first and see what happens.
If it will not work with that then you will definitely have to explore
different ways of holding the data.

Regards

Richard

 

[doyle60]

Thanks but it just isn't something that can or should be put into
separate fields. If I could, I would. There are aspects of it that
could be divided and I explained that to them. But there will always
be a big enough chunk of data that simply needs to go in a large memo.

Some databases hold "reports" and all sorts of things, of course. I
have one that holds letters. The text of the letter is a memo. It
would be nice to control the layout in that one too.

Matt