Tabulate Multiline Text in Records and Reports


The multiline text fields, which include Address, Note, and Text From Source, do not support any text formatting other than preset Left Tab Stops. Font styles such as Bold, Italic, Underline, Font Face, Point Size, or adjustable Tab Settings, as in a basic word-processor, are not available.

This poses a number of problems when attempting to create text that is neatly presented in both on screen Records and printed or online web page Reports.

In particular, using Tab characters to tabulate Text From Source to imitate, say a Census Record form, is challenging. The Tab width in Property Box fields is fixed, and does not correspond to the Tab Width settings in Reports. Thus, tidy tabulated data in the Property Box usually results in poorly tabulated data in Reports.

So here are some tips and tricks to make tabulating columns more successful.

Column Separators

Text From Source with Commas Some users avoid the tabulated column problem by using a column separator character such as Comma (,) or Bar (|) as in Comma Separated Value (CSV) files. The benefit being that if user adjustable Tab Settings were introduced by Family Historian, then these column separator characters could be automatically replaced by a single Tab character to create tidy columns. However, in the meantime, this precludes neatly tabulated columns, looks untidy, and it is difficult to tell which text is in which column.

Another snag with the default Comma (,) separator is where any column text contains a Comma (,) such as a place in Where Born. One workaround is to protect such text by enclosing it in string quotes ("). Another way is to use an alternative Comma as the separator, which can be entered by holding down the Alt key and entering 0130 on the number keypad.

Text From Source with Multiple Tabs To neatly tabulate a multiline text field, varying numbers of Tab characters must be used in each column, depending on how much text there is in the column. When some columns have no text, it is then not clear whether multiple Tab characters indicate multiple columns, or one wide column. If user adjustable Tab Settings were introduced by Family Historian, then these multiple Tab characters per column make it tedious to adjust to one Tab per column to honour the new Tab Settings.

Text From Source with Tab Bar Space A useful trick is to combine these two approaches by using a multi-character column separator such as Comma (,) Tab or alternatively Tab Bar (|) Space. Then a neat column layout can be achieved by adding extra Tab characters, and yet they can be automatically removed if adjustable Tab Settings become available. The Tab Bar (|) Space alternative looks particularly neat, as it imitates the vertical column separators found on real Census Forms.

Ancestral Sources allows Text From Source Auto Text Transcript column separators to be user defined for the Census Grid. To specify the multi-character separators suggested above, enter ,{TAB} or {TAB}| into the Other: separator box of the Grid Column Separator option.

Record Fields

Multiline Text Editing Modes

The Property Box multiline text fields may also be edited in an adjustable popup window.

Unfortunately, the character size and Tab settings are not quite identical in the two modes. Thus, it is occasionally necessary to add one or two extra Space characters to the end of a text string, in order to obtain tidy columns in both modes.

Report Options

If a Report includes tabulated multiline text fields, and uses the default Report Options, then the tabulated fields are often not in neat columns. This is caused by the Font and Tab Width not having the same relationship as in the Property Box fields.

Report Default Layout

The solution is to adjust the Report Options settings for the Format tab > Section Data > Font and the Page Layout tab > Tab Width and Para. Indent.

Report Options Format Font Report Options Page Layout

The following Font and Tab Width settings usually work well, providing the Tools > Preferences > Property Box Font is the default MS Sans Serif or alternatively Arial.

Format tab > Section Data Page Layout tab
Font Name Font Style Font Size Tab Width/Para. Indent
Arial Narrow 7 pt 0.35” 08.9 mm
Arial Narrow 8 pt 0.40” 10.2 mm
Arial Regular 8 pt 0.49” 12.5 mm
Arial Regular 9 pt 0.54” 13.7 mm
Arial Regular 10 pt 0.59” 15.0 mm
MS Sans Serif Regular 8 pt 0.49” 12.5 mm
MS Sans Serif Regular 9 pt 0.54” 13.7 mm
MS Sans Serif Regular 10 pt 0.59” 15.0 mm
Tahoma Regular 8 pt 0.47” 11.9 mm
Tahoma Regular 9 pt 0.53” 13.5 mm
Tahoma Regular 10 pt 0.59” 15.0 mm

Strangely, the Times New Roman default Reports Font did not give consistent results with any one Tab Width setting.

The Para. Indent must be 0” or 0 mm, or equal the Tab Width, because the Tab Width steps start from the Left Margin.

If Para. Indent = 0” or 0 mm the Sources reference numbers are rather obscured, but the characters per line is maximised.

Report Options Para. Indent = 0

If Para. Indent = Tab Width the Sources reference numbers stand out more clearly, but the characters per line is reduced.

Report Options Para. Indent = Tab Width

Importantly, each multiline text field such as Text From Source must start with a blank line, otherwise its first line in the Report follows on the same line as the Text From Source: heading, and does not align with the subsequent text.

For wide tabulated data, such as the UK 1911 Census, it may also be necessary to minimise the page margins. Use Page Layout tab > Margins and set both Left: and Right: to 0.1” or 2.5 mm. Alternatively, Orientation: Landscape may be needed.