Text macro

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

Guest

Can I create a macro in Access that will type in text. I would use it like
the autotext feature in Word
 
I want to fill in a comment field with the same comment numerous times for
example "client withdrawn before record received". I have several of these
comments, and in Word I have created "autotext" for them, but can't find a
way to do this in Access.
 
Jan,

There are a couple of approached to this. One is to make a table where
the commonly used comments are entered, make the Comments control on
your form as a combobox, and use this table as the Row Source of the
combobox. Set the combobox's Limit To List property to No so you can
enter a comment that is not included in the commonly used ones. With
the combobox's Auto Expand feature, you just type the first couple of
characters and it fills in the rest.

Another approach is to make a macro and name it AutoKeys. Have a look
in Help about this. Set a key combination for each such commonly used
comment, and then in the macro use the SetValue action, with the
arguments as such...
Item: [Screen].[ActiveControl]
Expression: "client withdrawn before record received"
 
Back
Top