-
Using the Fill Handle in Access
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.
-
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.)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules