Form Fields in Design View

[Raddy]

I'm new to Access so I hope you'll all bear with me

Is it possible to change the field lengths on input fields in Design View if the form was created using the wizard? If so, how?

 

[maxmangion]

you can change your field length(s) from the design view of your table.

 

[Raddy]

if I try to adjust one of the field lengths all the other fields adjust to thjat size?

 

[ghudson]

Do you want to adjust the number of characters allowed in that field or the physical size [width] of the field in your form?

 

[Raddy]

I want to change the size of the input fields - so that a 10 long 'phone number field is not the same length as a 25 long address field. I wonder if I have a control on that means all field lengths are tied together somehow.

I'm new to this - so thanks for your help

 

[ghudson]

I want to change the size of the input fields - so that a 10 long 'phone number field is not the same length as a 25 long address field. I wonder if I have a control on that means all field lengths are tied together somehow.

I'm new to this - so thanks for your help

Then that is a design change in the table. You set the Field Size property of that field to the number you want for that specific field.

 

[Raddy]

So Iset the zip code integer to 8 on the table. I set the Surname field to char 25 on the table. I create a form using the Wizard - and hey presto all the fields are the same (long....)length and can't be adjusted - they change en bloc. If I create the form manually I can have the DISPLAYED filed lengths any size I want.

 

[ghudson]

Real programmers do not use the wizards. ;-)

 

[Raddy]

Been codin' since 1981 my friend - and real programmers don't regard generating basic Access forms as programming. That's why it's so frustrating when you want to do a simple like change a field length and nobody knows how to help.

So, unless you are telling me that Wizard generated form fields can't have their length modified, then your comment don't help me

 

[boblarson]

I use wizards - they help get the initial stuff done. So there ghudson. (and I'm a real programmer)

The problem is this.

 

[Raddy]

boblarson
Thanks for your comment

Why does it always happen on forums. You have a question you need an answer to and some smart ass just has to get a dig in to try and come across as some superior geek - not able to give any help or assistance mind. We have a word for these people in the Uk which I think the moderator will ban me for using!

Still none the wiser as to my original problem

 

[boblarson]

boblarson

Still none the wiser as to my original problem

My link didn't shed light on it? It is the way Access 2007/2010 add items to the form. You have to UNLINK them (my link shows how).

 

[Raddy]

Thanks Boblarson
Just wanted to get the thing off my chest - the link and details are just what I was looking for

Cheers

 

[Cyfardda]

When you add fields to a form using the Wizard, they are joined in a block and any change you make to one of them will be made to all. There is a "detach" command in the menu ribbon. Click on the field you want to detach. Click the detach button and then move the field where you want it and make it any size or shape you want.