Re: printable size of memo field

Tech-Archive recommends: Fix windows errors by optimizing your registry

A more robust solution would be to add a table to hold the memo and a datetime
field for the memo and a field to relate the memo field to the report table.
That way you could print all the memos associated with a report, just the latest
memo associated with the report, or the last five (or other number).

The only way to do it with one memo field is to have some string of characters
that indicates the break between entries and then use vba to find that break and
delete all characters between the break and the end or beginning of the memo field.

How is the data entered into the memo field now? That is what does it look like?

Do you add new data at the beginning of the memo field? At the end of the memo
field? How do you decide which entries to keep? Do you want to keep all the
data, but just display some of it?



Roger wrote:

Hi all...
I'm a newby with a 'memo' field, question. I have made a database with
a memo field for inputting engineers reports on a weekly basis. Can I
make the older entries roll off when I enter the latest entries so
controlling the printout size of the memo field?
At present the printout can go into several pages of engineers history
which is not required.

Rojen
.

Relevant Pages

  • RE: Memo text box
    ... I have already changed the "Enter Key Behavior" from ... I click on it and delete specific entries. ... the Memo box and the user wants to add a new comment, I would like for it to ... sometimes we may want to delete a particular entry in the memo field but not ...
    (microsoft.public.access.gettingstarted)
  • RE: Binding objects with Carriage Returns
    ... The reason that I have to use a "memo" on both, the web-service requires me ... to do this to see all the entries. ...
    (microsoft.public.access.queries)
  • Re: Canadas Iranian Shame
    ... "You tell me why Bush had a "Deer in the Headlights" moment while reading my ... Does it support the position that intel was coming into ... White House releases bin Laden memo ... The declassified intelligence report said the FBI had detected "patterns ...
    (alt.guitar.amps)
  • Re: Using subform to display a history of previous memo boxes?
    ... >of the report there is a check box next each of these intervals. ... >the form there is a memo box called mmoNewInformation for New Info, ... >mmoNewInformation entries along with both the interval checkbox that was used ... Access assumes that if you're overwriting a field, ...
    (microsoft.public.access.forms)
  • Re: Found on "Ask Yahoo" ... If Hillary Were President
    ... Not quite enough info (who the memo was written to, presumably the Officer), ... report only as directed by the authority he is assigned-to. ... the SecDef included the words 'immediately' or 'directly' in the memo. ...
    (misc.news.internet.discuss)