Using the Fill Handle in Access

[phatrick]

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]

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...

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