Copying down a column in Microsoft Access

[Ratnest]

Hi,
I'm new to Microsoft Access today, so this is probably a very basic
question for all you clever people out there.

Anyone know how I copy down a column in Microsoft Access? It doesn't
seem to have the same functionality as Excel, i.e. I can't just write
in one cell and then drag this down or highlight a whole column and
have the contents of that cell reappear in every cell I've highlighted.

heeeeelp........

[fredg]

On 28 Oct 2005 11:02:20 -0700, Ratnest wrote:

Hi,
I'm new to Microsoft Access today, so this is probably a very basic
question for all you clever people out there.

Anyone know how I copy down a column in Microsoft Access? It doesn't
seem to have the same functionality as Excel, i.e. I can't just write
in one cell and then drag this down or highlight a whole column and
have the contents of that cell reappear in every cell I've highlighted.

heeeeelp........

The very basic answer is the you never, ever work in Table View.
If you create a form for data entry, you can copy the value in a field
(it's a field not a cell) from the last record viewed to the next one
by clicking Ctrl + ' in that field while you are in that next record.

It's time to get away from thinking Excel and start thinking Access.

You can also fill fields with a value using a query or code, but since
I have no idea what you are doing, I'll leave you here.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail