beginner: bound / unbound control

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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


rep.qa said:
hello! just started using microsoft access and i want to know why
Click to expand...
everytime i add a textbox always give me "unbound" type. please help how to
insert "bound" so i could enter or edit record.
 
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.
 
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


rep.qa said:
on design view of my form, the field list icon is not shown. but when i
Click to expand...
switch over to the run view the icon is there. why is it like that?
 
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?
 
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


rep.qa said:
hello! just started using microsoft access and i want to know why everytime i
Click to expand...
add a textbox always give me "unbound" type. please help how to insert "bound"
so i could enter or edit record.
 
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


rep.qa said:
hello! just started using microsoft access and i want to know why everytime
Click to expand...
add a textbox always give me "unbound" type. please help how to insert "bound
so i could enter or edit record
 
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


rep said:
i can see now the field list icon on the design view of the form but i
Click to expand...
can't clicl on it. what shall i do?
 
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


rep.qa said:
i want to use my own form but can't insert a bounded textbox control. field
Click to expand...
list icon is there but it's not selectable (reverse mode video). what else can i
use. thanks.
 
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.
 
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


rep said:
that could be the reason. but how can i bound the form to a table or
Click to expand...
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.
 
Back
Top