Note that if you look at the field properties for the Address field it will give you the name of the Subfields. for example [Address: City]
Ok I have probably not given enough information. I am using the Field Type “Address” which is a lookup field that then automatically, when an address is found, fills in the subfields “Street 1”, “Street 2”, etc. The “Address” field is in a table called Properties. My users will be working mainly in a table called Commissions which is a child table to Properties. When a user wants to add a commission, it has a dropdown for Properties to look and see if that property is already in the database. If the property is not then they choose the “Add a Property” choice. The Properties report I am using to filter the dropdown is open properties and will be mainly 100 – 200 properties. My problem is the dropdown needs to be alphabetized by Street Name and not by the first Street Numbers, because scrolling through 100 – 200 items is not very workable. So I tried to add a formula text field to take the characters off up to the first space, but I can’t seem to do it. The thought is then I can add that formula text field to the report and sort by that field. So even though the user sees the numbers before the street name, it is still only by the street name. Tried NotLeft([Address],” “) and NotLeft([Street 1},” “) and cannot get it to work. Hopefully this is not too much information.
I did test the following formula but it did not seem to get posted with my response as i intended.
NotLeft([Address: Street 1], " ")