Form TextBox Issues

[Growler]

I'm running into an issue where the Access form allows the user to enter in 255 characters for TransmittalDetails1 through 5, but will only allow around 50 characters for TransmittalDetails6. Do you know why this is?
Thanks

 

[John Big Booty]

Is TransmittalDetails6 perhaps set as a text box rather than a Memo field?

 

[Growler]

How would I be able to check this? And, to mitigate this, I copy and pasted TransmittalDetails5, and renamed it TransmittalDetails6, so it would retain the same properties... So I am not sure if that is the issue.

 

[John Big Booty]

You'll need to check the underlying table in design view and check the Data Type of TransmittalDetails6

 

[John Big Booty]

If TransmittalDetails5 is a text box, the default field size for text boxes is 50, so perhaps in copying it the copied version (TransmittalDetails6) has reverted to the default rather than the expanded size of 250 of TransmittalDetails5.

 

[Growler]

You'll need to check the underlying table in design view and check the Data Type of TransmittalDetails6

I'm guessing it is of type Text Box... But so are TransmittalDetails 1 through 5

 

[John Big Booty]

It's a text box, the default field size for text boxes is 50 with a maximum of 255. So I suspect in copying and pasting you loose the expanded field size, so you will need to change the field size, in the design view.

 

[Growler]

It's a text box, the default field size for text boxes is 50 with a maximum of 255. So I suspect in copying and pasting you loose the expanded field size, so you will need to change the field size, in the design view.

Right, I want to adjust the size of the text box... but there's no place for me to do so in Design View. Can you point me to it please?

Thanks

 

[boblarson]

I'm guessing it is of type Text Box... But so are TransmittalDetails 1 through 5

You are showing the TEXT BOX properties but you should be looking in the TABLE at the FIELD properties.

 

[Growler]

You are showing the TEXT BOX properties but you should be looking in the TABLE at the FIELD properties.

How do I get there? All I have is a Property Sheet for my form.

 

[boblarson]

How do I get there? All I have is a Property Sheet for my form.

You open the TABLE in design view and then go select that field and look at the FIELD SIZE for it.

 

[boblarson]

Here's a sample:

 

[Growler]

You open the TABLE in design view and then go select that field and look at the FIELD SIZE for it.

I'm sorry, I'm not familiar at all with Access... my boss just told me to see if I could solve this issue for her. She gave me only one file to look at, TRANSMITTALS.mdb, and when I open it, all it shows me on the left-hand menu is "FORMS", and on the right is "PROPERTY SHEET".

That's all I see. How do I open this form in a table?

 

[Growler]

Here's a sample:

I've been looking for that, but I don't have it.
This is all I have:

 

[Kryst51]

There is a drop down at the top of your left hand menu, switch it to tables.

 

[boblarson]

I'm sorry, I'm not familiar at all with Access... my boss just told me to see if I could solve this issue for her. She gave me only one file to look at, TRANSMITTALS.mdb, and when I open it, all it shows me on the left-hand menu is "FORMS", and on the right is "PROPERTY SHEET".

That's all I see. How do I open this form in a table?

I'm assuming you have Access 2007 based on your description. See below for how to get to the tables and design view:

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=34139&stc=1&d=1287159348

 

[Growler]

There is a drop down at the top of your left hand menu, switch it to tables.

I did this... but when I switch it to TABLES view... the TRANSMITTAL form I need to work on does not appear

 

[boblarson]

You aren't gathering that you do not need the form. You need the table that is bound to the form. You should not be looking for the form you should be looking for the table that the form's RECORD SOURCE is based on.

 

[Growler]

You aren't gathering that you do not need the form. You need the table that is bound to the form. You should not be looking for the form you should be looking for the table that the form's RECORD SOURCE is based on.

Got it. The only thing I really needed clarification on I guess was what you just said right here. Thank you for your help.

-Dan

 

[boblarson]

Got it. The only thing I really needed clarification on I guess was what you just said right here. Thank you for your help.

-Dan

So did you find out if the field size was set too small?