Text box

  • Thread starter Thread starter Fiona
  • Start date Start date
F

Fiona

Hi
I'm very new to access so sorry if this is a very silly question! I have
created a form but one of the text boxes will only let me enter about 10-15
characters in the form view. When I put it in the design view I can write a
lot more.

How do i change it so I can write as much as i want in form view??

thank you
 
Your textbox is probably link to a table right? If so, the textbox has the
same limitation as your table field. If you set the maximum caractere to 10
in your table, you will not be able to type more then that in your textbox.


Hope it will help
 
Thanks Yanick
DO you know how I make change the coloumn size in the table so it allows for
more characters??
Many thanks
Fiona
 
Open your table in design mode then change the value "Field size" (Should be
the first one) for the field link to your textbox to the size you need.

That's it! There is many thing you can set at a table level. I recommend you
to take a look at the other parameters.
 
Thanks Yanick! That solved it.

The only other problem i'm having is, I've intserted additional coloumns in
to my table, after I have created a form, but when I re-open the form the
additional coloumns are not in there? I view in design few and still cannot
see them.

Is it possible to insert extra fields once a form has been written??

Thanks agian
 
Yes it is.

All you have to do is to add a new textbox to your form, right click on the
new textbox, choose properties, then data tab and change the "control source"
field to point to your new table field.

That should do the trick.
 
Thank you Yanick! You are brilliant!
Fiona

Yanick said:
Yes it is.

All you have to do is to add a new textbox to your form, right click on the
new textbox, choose properties, then data tab and change the "control source"
field to point to your new table field.

That should do the trick.
Click to expand...
 
Back
Top