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 / Forms / May 2006

Tip: Looking for answers? Try searching our database.

List box question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TKM - 26 May 2006 19:22 GMT
I ahve a list box with 3 letters an end user can select. Y, N,U. I would like
the default to be "Y" and put it in my tablse as such if the end user does
not select one at all. Can someone provide me the expression and where you
would put this in the the properties. Thank you
Wayne-I-M - 26 May 2006 22:53 GMT
Control Source = [FieldName]
Row Source Type = Value List
Row Source = "Y";"N";"U"
Bound Column = 1
Default Value = "Y"

Signature

Wayne

> I ahve a list box with 3 letters an end user can select. Y, N,U. I would like
> the default to be "Y" and put it in my tablse as such if the end user does
> not select one at all. Can someone provide me the expression and where you
> would put this in the the properties. Thank you
TKM - 31 May 2006 16:09 GMT
Yes that is what I have and it just leaves it blank without putting anythig
in the field.

> Control Source = [FieldName]
> Row Source Type = Value List
[quoted text clipped - 6 lines]
> > not select one at all. Can someone provide me the expression and where you
> > would put this in the the properties. Thank you
 
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



©2008 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.