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
--
Scafidel
Lafayette, Louisiana

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.

"Scafidel" <(E-Mail Removed)> wrote in message
news:5D9A5F34-CB48-4641-95AC-(E-Mail Removed)...
>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
> --
> Scafidel
> Lafayette, Louisiana