convert bound to unbound

  • Thread starter Thread starter Scafidel
  • Start date Start date
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
 
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.
 
Back
Top