Automatically going to last entry in a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a large memo field that lots of data gets entered into, I was
wondering is there a way to get the cursor to goto the end of the document
when you click onto the field so as to save having to scroll through it all
each time? Thanks, WK
 
Hi again bilbo+,

Have you considered replacing your large memo field with a notes table (or
similar), that way each note has a date/user stamp if need be and you can
easily find records that meet your interest?

Damian.
 
yeah a notes field that date stamps it sounds perfect, how would i go about
doing that? thanks for all your help by the wya...!
 
Hi again...

Create a table called something meaningful eg: tblClientNotes. Have the
following fields:

ClientNoteID autonumber
ClientID number (maps to the ClientID field in the Clients table - assuming
this is who the notes are for)
ClientNoteDate datetime
ClientNoteDetails text 250

Link your Client Table to the Client Notes table.

Create a continuous form to display your client Notes, insert that form into
a subform of your main form and link the ID fields between the main form and
subform.

Set some field default data values such as =date() for the NOte Date field.

All done.

Damian.
 
Hello again, I was thinking, if I create it in that way, if i have say 300
words of text, will the text not dissappear since it only shows one line? So
basically i was thinking... how can i do it so it shows all the text? i have
created all that... so im wondering eitehr to scrap that and try to
automatically goto the end of the memo... or somehow make it so the form
datasheet shows all the text?.. you said continuous form... im not sure what
you meant.. maybe thats what im doing wrong, i just used the wizard to create
a datasheet form with the detail and date fields and the other two hidden...
help!
 
For me, F2 places the cursor at the end of the field. If this works for you,
try the command SendKeys {F2}.
 
Back
Top