If there are too many columns and some are cut off, a “placeholder” column will be displayed at the end indicating how many additional fields have been cut off. In this example there are 13 additional fields that are not being displayed in the data sheet.
The cutoff number applies only to the data sheet – all fields can still be accessed in forms (including printing), via a formula, via import/export, joins, and all other methods.
If you need to access fields beyond the cutoff in the data sheet, use Panorama’s feature for Hiding and Showing Fields. You can hide individual fields or you can even set up favorite configurations of visible vs. hidden fields. You can display any combination of fields that you like as long as the total doesn’t exceed the cutoff number.
The cutoff limit for data sheet columns can be adjusted using the Advanced panel of the Preferences window.
If you choose a value over the normal limit, Panorama will ask you to confirm that you really want to do this. To confirm, press the Accept Slow Performance button.
Panorama will immediately update all open data sheet windows to reflect this change. You may see a delay (or even beachballs) as this transition is made.
A warning icon will appear whenver the limit is set above the normal value. If the value is slightly above the limit the icon will be orange, if way over the limit the icon will be red.
Instead of increasing the cutoff limit (and possibly encountering poor performance), consider hiding fields you don’t need at the moment (see Hiding and Showing Fields).
|10.2||New||New in this version.|