basic help with access

H

happy_crazy_hannah

I just wanted to know if it is possible to make it so that in access, if you
have already typed something in above that cell in the colum (eg have typed
in Footscray a few rows up), when i type in something (eg Footsc) then the
rest will atomatical appear. This happens in Excel, and I think it would be
great for access. Is it possible?
 
D

Douglas J. Steele

No, it's not possible but, to be honest, it doesn't strike me as all that
useful for a properly designed database since it should be rare to have the
same text repeating on multiple rows.
 
J

John Vinson

I just wanted to know if it is possible to make it so that in access, if you
have already typed something in above that cell in the colum (eg have typed
in Footscray a few rows up), when i type in something (eg Footsc) then the
rest will atomatical appear. This happens in Excel, and I think it would be
great for access. Is it possible?
Click to expand...

Douglas is (as always) correct; just let me comment that if you use a
Form with a Combo Box (much preferable to using a table datasheet),
that the Combo has an autocomplete property just as you describe.

John W. Vinson[MVP]
 
Top