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" <jerryscafidel@bellsouth.net> wrote in message 
news:5D9A5F34-CB48-4641-95AC-FA997293DEA5@microsoft.com...
>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