<div>
There is no good way to do this. &nbsp;For starters, the controls on a form do not automatically resize as the controls on a report do (vertical only though). &nbsp;That means you would have to do it manually. &nbsp;How would you determine the width should you decide you really want to do this? &nbsp;Well, for starters, you will have to figure out the maximum character count of of each column &nbsp;by examining the recordset returned by the Form's ControlSource. &nbsp;If the ControlSource is the table name rather than a query with criteria, you will be analyzing every single row in the table. &nbsp;Just knowing the character count of a field is not sufficient for determining the width because you also need to know whether you are using a proportional or non-proportional font and the point size. &nbsp;an &quot;i&quot; takes far less space than a &quot;W&quot; and you would need to include that in your calculation. &nbsp;Once you have determined the width required for each column, you need to decide if the form is wide enough. &nbsp;Do you also want to make the form wider? &nbsp;If not, how do you decide which column to make narrower. &nbsp;Then you need to decide if there should be any space between controls and create the loop to reposition all the controls based on your calculations.<br />
<br />
And on and on and on.<br />
<br />
Try using DS view. &nbsp;The columns can be resized either with code or manually and the height and column order may also be adjusted. &nbsp;If you want the values to be saved, you will need to create a table in which to store the values for EACH user and code to do it.
</div>


<div>
Hi Pat,<br />
Thanks for your reply. <br />
I already have a module that repositions my controls on the form I just wanted to know if I could find a way or customize my module to remove extra spaces in the textboxes.<br />
<br />
Public Sub PositionFields()<br />
<br />
&nbsp; &nbsp; Dim strSQL As String<br />
&nbsp; &nbsp; Dim RS As DAO.Recordset<br />
&nbsp; &nbsp; Dim lngLeft As Long<br />
&nbsp; &nbsp; Dim ctrl As Control<br />
&nbsp; &nbsp; Dim frm As Form<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Set frm = Forms!frmItem<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; strSQL = &quot;SELECT DisplayThis, FieldName FROM tbl_Field_Sort_and_Select &quot;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&amp; &quot;ORDER BY Sort_Order&quot;<br />
&nbsp; &nbsp; Set RS = CurrentDb.OpenRecordset(st<wbr />rSQL, , dbFailOnError)<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; lngLeft = 0.5 * 1440<br />
&nbsp; &nbsp; While Not RS.EOF<br />
&nbsp; &nbsp; &nbsp; &nbsp; Set ctrl = frm.Controls(&quot;lbl_&quot; &amp;&nbsp;RS(&quot;FieldName&quot;))<br />
&nbsp; &nbsp; &nbsp; &nbsp; ctrl.Visible = RS(&quot;DisplayThis&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; ctrl.Left = lngLeft<br />
&nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; Set ctrl = frm.Controls(&quot;txt_&quot; &amp;&nbsp;RS(&quot;FieldName&quot;))<br />
&nbsp; &nbsp; &nbsp; &nbsp; ctrl.Visible = RS(&quot;DisplayThis&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; ctrl.Left = lngLeft<br />
&nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; lngLeft = ctrl.Left - ctrl.Width * RS(&quot;DisplayThis&quot;)<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; RS.MoveNext<br />
&nbsp; &nbsp; Wend<br />
&nbsp; &nbsp; RS.Close<br />
&nbsp; &nbsp; Set RS = Nothing<br />
<br />
<br />
<br />
End Sub
</div>


<div>
Well you've gotten that far, you might as well figure out an average twips width for each character given the font and point size you are using and count the characters in each column. &nbsp;That will allow you to determine a width for the maximum length piece of data in the recordset. &nbsp;It won't be exact but it should be close.<br />
<br />
BTW - this is not a normal feature of a user app. &nbsp;If you have to do it, it may be due to a design flaw in your schema.
</div>


<div>
May be I should just change my design schema.
</div>


<div>
It's hard to say since we don't know what the current schema is or why you embarked on this design that requires design changes at runtime.<br />
<br />
In general, it is poor practice to make design changes at runtime since it prevents you from distributing as an .accde or .accdr or from using the Access runtime. &nbsp;Design changes cause bloat so you would also have to deal with that and finally, you shouldn't be sharing the actual FE and making design changes at runtime will absolutely prevent this.
</div>


<div>
well I was asked to develop an access database for project cost estimation with 2 parts.<br />
&nbsp;one part to retreive Item costs and the other one to make calculations to estimate a project.<br />
<br />
All the data were already stored in a excel file. So I started by creating one access table from my excel file. the result was a table with more than 10 columns that made my form larger to fit on one screen.
</div>


<div>
I've finally changed my mind thanks to yours comments and what I need now, It's to build a database that will manage cost data so that we estimate project costs.<br />
<br />
thanks for your support.
</div>


<div>
You're welcome &nbsp;<br />
<br />
I have a sample app that uses what I call &quot;bound denormalized forms&quot; that is very appropriate for forecasting. &nbsp;I'll attach a .pdf with an outline but the actual database is to large to post on EE. &nbsp;If you think you want it when you get into the design, drop me a PM and include your email so I can send it to you.<a href="https://filedb.experts-exchange.com/incoming/2017/12_w50/1215504/Bound-Denormalized-Forms.pdf" target="_blank" class="file-inline" title="Bound-Denormalized-Forms.pdf (317 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Bound-Denormalized-Forms.pdf</a>
</div>


Bound-Denormalized-Forms.pdf

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I want to fit my controls to their contents and also my form to Its too but I don't know to proceed.<br />
<br />
&nbsp; 1) In my controls, I would like to dynamically remove the extra spaces by making a go to the line<br />
&nbsp; 2) As for my form, It's to fit to Its content in whatever screen It's displayed.<br />
<br />
Please see the attached image<br />
<br />
I will &nbsp;be gratefull for any reply from you.<br />
<br />
Thanks in advance<br />
<br />
* Sorry for my English I'm from a french country<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w48/1212732/C--Users-L0340909-Pictures-form-imag.JPG" target="_blank" class="file-inline" title="C--Users-L0340909-Pictures-form-imag.JPG (102 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>C--Users-L0340909-Pictures-form-imag.JPG</a>
</div>
</div>


C--Users-L0340909-Pictures-form-imag.JPG

Hello,

I want to fit my controls to their contents and also my form to Its too but I don't know to proceed.

  1) In my controls, I would like to dynamically remove the extra spaces by making a go to the line
  2) As for my form, It's to fit to Its content in whatever screen It's displayed.

Please see the attached image

I will  be gratefull for any reply from you.

Thanks in advance

* Sorry for my English I'm from a french country

How can I fit my form and controls to their contents

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.