PDA

View Full Version : Using the Fill Handle in Access



phatrick
07-28-2005, 02:19 PM
Does anyone know if you can put some sort of control or feature on a form in a datasheet view that would allow you to populate data in a similar manner as the fill handle does in excel? I would like to be able to just select an attribute and copy the value down.

xCav8r
07-29-2005, 09:25 PM
That would be a nice feature, but you can't do it in Access. Your alternative is from a table, query results, or datasheet form...

Tools | Office Links | Analyze it with Excel
Drag and fill as desired.
Copy cells.
Paste into datasheet form, table, or query. (This could potentially run into some conversion issues if you're not careful about your data types.)