How can I search on part of a name in a form?
On the left of the form's navigation bar, amongst other things, there is a search utility, currently (LO 3.4.5) the icon is a magnifying glass.
Clicking this button opens a dialogue for entering search criteria, the field(s) to search, and other settings for the search.
Most often, this is simply used to specify the exact text to find.
The example in the screenshot shows how to look for rows containing firstnames ("prénoms") starting with "Anto".
- Click on the search button to find the required text.
- When the end of the file is reached, the search automatically continues from the beginning.
Don't confuse this utility with "Search and Replace" in the standard utility bar, which has a pair of binoculars on it.