Allowing when typing in same information in a field

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

Guest

I have set up a table and I want some of the fields to "auto fill" when I
type in the first letter. Much like Excel when you have to type in the same
information in a field over and over - it auto fills the field once you have
typed in the first one or two letters. How do I set up some my fields to do
this?
 
I thought there was an easier way, instead of using a combo obx, since one my
fields is a date field. I dont want to have to add the dates into the combo
box in order to select it. Also, the information in the fields changes
daily. In other words, I might have 50 lines that I have input in one day
where 6 fields are the same. Then the next day, I might have 50 more lines
of input where the information in these fields has changed from the day
prior, but the same for that day.

I recall being able to have this happen when I worked in Access before, but
unfortunately I dont remember how to set it up!

thanks for any info
 
Are you referring to repeating the value that was inputted
in the previous record? If so use the Microsoft shortcut.
Click in the field in which you want to insert the value.

Press CTRL+APOSTROPHE (').

Chris
 
Chris Reveille said:
Are you referring to repeating the value that was inputted
in the previous record? If so use the Microsoft shortcut.
Click in the field in which you want to insert the value.

Press CTRL+APOSTROPHE (').

Chris
Click to expand...
 
Chris-thanks for your help. I am typing my information directly into the
table. I may have to input 30-40 lines of information to the table. As I
tab over to the next field in the table and start to type in the same
information, I want the field to "recognize" the first one of two letters or
numbers I am typing and then auto fill in the rest. Excel does this all the
time when you are typing the same information over and over. It "auto fillS"
the cell, based upon what you typed in prevously.
I know that I have set this up before, but I cannopt remember how I did it!
Any light you can shed, would be helpful.
Thanks
 
Back
Top