Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

convert bound to unbound

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scafidel - 17 Jan 2008 15:11 GMT
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
Signature

Scafidel
Lafayette, Louisiana

BruceM - 17 Jan 2008 15:31 GMT
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.

>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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.