 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Text box
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  SignatureYanick > Hi > I'm very new to access so sorry if this is a very silly question! I have [quoted text clipped - 5 lines] > > thank you Thanks Yanick DO you know how I make change the coloumn size in the table so it allows for more characters?? Many thanks Fiona > 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 [quoted text clipped - 11 lines] > > > > thank you 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. SignatureYanick > Thanks Yanick > DO you know how I make change the coloumn size in the table so it allows for [quoted text clipped - 17 lines] > > > > > > thank you 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 > 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. [quoted text clipped - 23 lines] > > > > > > > > thank you 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. SignatureYanick > Thanks Yanick! That solved it. > [quoted text clipped - 34 lines] > > > > > > > > > > thank you Thank you Yanick! You are brilliant! Fiona > Yes it is. > [quoted text clipped - 42 lines] > > > > > > > > > > > > thank you |
Reply to this Message |
 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.