Check Box Translated to Text

[Guest]

Hi

I am setting up a database with check boxes for Services that are offered.
What i would like to do is convert the values into specific text. So for
instance, if the check box for Project Management and Quantity Surveying is
ticked, a summary can be placed in a text box such as QS, PM to show that
these two are selected. Any ideas?

Mike

 

[strive4peace]

don't use checkbox Fields, use Related table
---


Hi Mike,

you should not be using check boxes for Services

Instead, you need to set up a Services table

*Services*
ServID, autonumber
Service, text

and then a table to keep track of what services are chosen for the main
record would be the recordsource for the subform

*MainServices*
MainServID, autonumber
ServID, long integer -- foreign key (FK) to Services
MainID, long integer -- foreign key (FK) to the "Main" table (whatever
it is really called)

and you could use a continuous subform to indicate what services are
included with your main record

~~~~~~~~~~~~
once this is done, we can help you with code to concatenate the Service
value for all the services chosen for a particular MainID

~~~~~~~~~~~
for better understanding, download and read this:

Access Basics
http://allenbrowne.com/tips.html
Tips for Casual Users
Access Basics: free tutorial - Word document by Crystal (Access MVP)

This 30-page training tutorial will orient you toward the core concepts
of Microsoft Access -- good foundation for learning programming




Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*