How to tick say 200 entries quickly ?

[Steve]

In my table, I have field with Yes/No in design view, becomes tickbox in
normal view, how can I tick quickly say 200 fields in one go, tried dragging
cursor down over them, Tried down arrow and hit enter but that jumps to next
column.
Steve

 

[Rick Brandt]

In my table, I have field with Yes/No in design view, becomes tickbox in
normal view, how can I tick quickly say 200 fields in one go, tried dragging
cursor down over them, Tried down arrow and hit enter but that jumps to next

No way I know of using the GUI. You could run an update query on the underlying
data or use some VBA code.

 

[Daniel]

Have you tried an update query? Probably your best bet. You could also
create a loop in vba to run through your records and change the values but I
would try the update query first!

Daniel

 

[Steve]

Cheers for the replies,
need read about update queries then, ah well.
Steve