How to tick say 200 entries quickly ?

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
Steve said:
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
Click to expand...

No way I know of using the GUI. You could run an update query on the underlying
data or use some VBA code.
 
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
 
Back
Top