convert bound to unbound

S

Scafidel

I am cleaning up my database and would like to convert several bound fields
to unbound text. When I created the database, every field was bound. The
form requires combinations of fields and repetitions, i.e., date, ordinal
date, etc. This makes for an awful looking table.
Is there an easy way to do this?
Thanks
 
B

BruceM

The appearance of the table is not relevant, but the data organization is.
You can make a bound control unbound by removing its control source, but to
what end? A bound control is linked to a field in the underlying recordset
(the Record Source for the form or report), but the field itself is neither
bound nor unbound.
What is the difference between date and ordinal date? Are they two ways of
expressing the same thing? If so, there is no reason to store the
information more than once. You can leave one text box bound to DateField
(or whatever you call your date field), and set the other's control source
to something such as:
=Format([DateField],"dd-mmm-yyyy")
or whatever exactly you need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top