FormatCondition.LongestBarLimit (Access)

Gets or sets how the longest data bar is evaluated for the specified FormatCondition. Possible return values are acAutomatic - For the shortest bar, the lowest value is used. For the highest bar, the highest value is used, acNumber - A number is used, acPercent - A percentage is used.

By default, the highest value is used to determine the length of the longest data bar.

CreateForm.Controls(1).FormatConditions(1).LongestBarLimit = acAutomatic