G
Guest
hello! just started using microsoft access and i want to know why everytime i add a textbox always give me "unbound" type. please help how to insert "bound" so i could enter or edit record.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Cheryl Fischer
Instead of dragging a TextBox control from the toolbar to your report's
design, look for the Field List icon. It will contain a list of each field
in the Record Source (table or query) of your form. Click the Field List
icon, and you can drag a field to your report's design view which will
automatically be a bound control.
hth,
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
insert "bound" so i could enter or edit record.
design, look for the Field List icon. It will contain a list of each field
in the Record Source (table or query) of your form. Click the Field List
icon, and you can drag a field to your report's design view which will
automatically be a bound control.
hth,
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
everytime i add a textbox always give me "unbound" type. please help how torep.qa said:hello! just started using microsoft access and i want to know why
insert "bound" so i could enter or edit record.
G
Guest
on design view of my form, the field list icon is not shown. but when i switch over to the run view the icon is there. why is it like that?
thanks.
thanks.
C
Cheryl Fischer
The Field List icon is in the Form Design toolbar, which you may have turned
off. Right-Click on any blank area of the toolbar while in design view of
your form and select the Form Design toolbar.
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
off. Right-Click on any blank area of the toolbar while in design view of
your form and select the Form Design toolbar.
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
switch over to the run view the icon is there. why is it like that?rep.qa said:on design view of my form, the field list icon is not shown. but when i
G
Guest
i can see now the field list icon on the design view of the form but i can't clicl on it. what shall i do?
P
PC Datasheet
Use the form wizard when you first create your form and you will be able to
select the fields you want on the form and they all will be bound!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
so i could enter or edit record.
select the fields you want on the form and they all will be bound!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
add a textbox always give me "unbound" type. please help how to insert "bound"rep.qa said:hello! just started using microsoft access and i want to know why everytime i
so i could enter or edit record.
G
Guest
i want to use my own form but can't insert a bounded textbox control. field list icon is there but it's not selectable (reverse mode video). what else can i use. thanks
----- PC Datasheet wrote: ----
Use the form wizard when you first create your form and you will be able t
select the fields you want on the form and they all will be bound
-
PC Datashee
Your Resource For Help With Access, Excel And Word Application
(e-mail address removed)
www.pcdatasheet.co
so i could enter or edit record
----- PC Datasheet wrote: ----
Use the form wizard when you first create your form and you will be able t
select the fields you want on the form and they all will be bound
-
PC Datashee
Your Resource For Help With Access, Excel And Word Application
(e-mail address removed)
www.pcdatasheet.co
add a textbox always give me "unbound" type. please help how to insert "boundrep.qa said:hello! just started using microsoft access and i want to know why everytime
so i could enter or edit record
C
Cheryl Fischer
When I look at a form that is not bound to a table or query (i.e., does
*not* have a Record Source), the icon is disabled and not clickable. Could
that be the problem?
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
*not* have a Record Source), the icon is disabled and not clickable. Could
that be the problem?
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
can't clicl on it. what shall i do?rep said:i can see now the field list icon on the design view of the form but i
P
PC Datasheet
After using the form wizard, the form will be your own. You can go to properties
and change whatever you like such as single or continuous form and full screen
form or popup form.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
use. thanks.
and change whatever you like such as single or continuous form and full screen
form or popup form.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
list icon is there but it's not selectable (reverse mode video). what else can irep.qa said:i want to use my own form but can't insert a bounded textbox control. field
use. thanks.
G
Guest
that could be the reason. but how can i bound the form to a table or query? when i create the form using the wizard, it is automatically bounded to a table but if i custom build a form, everything i add is unbounded.
C
Cheryl Fischer
Open the form in design view and then open the Properties for the form.
Look for the RecordSource property of the form, where you can enter the name
of a table or a query. When you have done that, you will have a bound form.
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
to a table but if i custom build a form, everything i add is unbounded.
Look for the RecordSource property of the form, where you can enter the name
of a table or a query. When you have done that, you will have a bound form.
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
query? when i create the form using the wizard, it is automatically boundedrep said:that could be the reason. but how can i bound the form to a table or
to a table but if i custom build a form, everything i add is unbounded.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.