I typed up a lot of stuff into a table and i need to insert tick boxes. Is
there an easier way of doing it, other than add colums and cut & paste.

If you mean check boxes, one can only use Yes/No check boxes in a Jet table,
not multiple choice check boxes.  And if you mean you need to convert the
words, numbers, or dates you already typed in one column into Yes/No check
boxes for the new check box column, then you'll need a formula for the
conversion.  Please give us more information on what you want to convert and
someone can probably guide you.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


Show quoteHide quote

Hi, Batune.

And you might want to repost in either the
microsoft.public.access.tablesdbdesign or microsoft.public.access newsgroup,
because this isn't really a security issue.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


Show quoteHide quote

"Tick boxes" are a Yes/No data type, also known in Access as either 0 or -1.

If all your data was those values, then you should be able to convert the data
type. If some of them were not those values, then you would get conversion
errors.

A safer way might be to write an Update Query to update a new field with the
equivalent of the old field. If you only have several hundred records, it
might be easier to just browse/update the values in that field, but either way
they MUST be converted to (0 or -1) to use a tick box.

If the original field contains multiple values, you would need to decide what
value gets updated to 0 and what gets updated to -1, whether you automate or
manualise the conversion. If there are more values than that, then it's not a
tick box! (it's a combo box)

Better to get the design right in the "experimentation stage", though
certainly I've had to make changes like this! You have to tell it (somehow)
how to convert what-to-what, because "it" sure doesn't know.

Chris

Show quoteHide quote

More security questions
Getting started with security
Frontend Downloads
Access 2003 on wondows XP de-secure problem
Read only report
Encode/Decode Data Base
Error 7399 When trying to link an Access database to SqlServer 2K
Error 0x80040E4D when tryng to open an password protected Access database programmatically
Problem accessing Access from ShortCut.
Desperate housewife needs help with user profiles....