I have a form that concatenates two fields:
CAR_Number (Drop Down)
CAR_Number1 (Editable Field)
into CARNumberComputed .
I created CarNumberComputed so that the one form number will be shown when data is entered.
The following code is in value for CarNumberComputed:
myList := CAR_Number: CAR_Number_1; myList
For some reason, I get a semicolon in between the fields e.g. CAR_Number;CAR_Number1 or just ; if nothing has been typed yet.
This is odd because I have used this line of code elsewhere and it does not show the ; and I cant seem to get rid of it.
The second part of this concerns the same fields. I need for CARNumberComputed to only show the first digit of the CAR_Number field. For instance, the drop down allows the user to choose A - Audit then type in their digits 3455 for the CAR_Number1 field. I want CARNumberComputed to show only A3455 or A-3455.