StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>The "magic" properties to look:</p> <p><strong>If in Form Design,</strong> </p> <ul> <li>right click the offending field > Properties > Format > Column Widths</li> <li>right click the offending field > Properties > Format > Column Count</li> <li>right click the offending field > Properties > Data > Row Source</li> <li>right click the offending field > Properties > Data > Bound Column</li> </ul> <p><strong>If in Table Design,</strong></p> <ul> <li>Select the offending field > Field Properties (look below) > Lookup tab > Row Source</li> <li>Select the offending field > Field Properties (look below) > Lookup tab > Bound Column</li> <li>Select the offending field > Field Properties (look below) > Lookup tab > Column Count</li> <li>Select the offending field > Field Properties (look below) > Lookup tab > Column Widths</li> </ul> <p><strong>What is what?</strong></p> <ul> <li>Your Row Source is a table (either from an actual table or query result) where it has columns.</li> <li>The Bound Column is the column which your form will take the value from.</li> <li>The column count is the number of columns to "display" from the Row Source, starting from the Row Source's first column.</li> <li>Columns Widths lets you set the width of the displayed columns. To hide a particular column, set the width to 0. The syntax to set the width is: #;#;#... where each # is a number, the width of the corresponding column in sequence.</li> </ul> <p>In the case of your cust_name, check all the values in the abovementioned fields. Assuming your customer_id is in column one and cust_name in column two. Then you have the following settings:</p> <pre><code>Row Source = customer_table Bound Column = 1 Column Count = 2 Column Width = 0;3 </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload