Macro solution to search for character within a text string.

Access 2000 Macro solution wanted. I have created a macro that looks at an address field (43 Oxford St)and reads the last two characters entered to complete the address. For example if the last two characters are 'ro' it adds 'ad' to read road....