I was wondering if anyone has done this in the modern forms designer. We use a lookup table to auto fill in the first name and middle initial of employees. In the Classic designer I could set the single field to 1 character to only fill in the first letter of the middle name. However in the modern designer this no longer works. I have tried a few different functions but can't seem to figure out how to return just the first letter of the middle name.

So trying to truncate all characters after the first letter.