2007 Autofill in datasheets?

[damo1960]

Access 2007 apparently no longer has the autofill feature with datasheets. This was an option that I used frequently and not having slows down greatly my particular tasks.
Is there some way of activating it?

 

[boblarson]

Don't know if this will help, as I couldn't find it explicitly for autofilling but see if this might at least make it easier:

Insert the value from the same field in the previous record
CTRL+APOSTROPHE (')

 

[damo1960]

Don't know if this will help, as I couldn't find it explicitly for autofilling but see if this might at least make it easier:

Insert the value from the same field in the previous record
CTRL+APOSTROPHE (')

thanks for replying. It at least makes it a bit less time consuming

 

[FreshPlantain]

Beautiful. Now how to trigger with VBA?

 

[wiklendt]

Have you tried 'sendkeys'?

 

[FreshPlantain]

Have you tried 'sendkeys'?

Yes that works

SendKeys "^'"

Thank you very much!