When you do the following It will not trim advice would be appricated


DIM PROBLEM AS STRING * 50

PROBLEM = "PROD"
PROBLEM = RTrim(Mid(PROBLEM , 1, InStr(1, PROBLEM , " ") - 1))

FOR SOME REASON IT DOES NOT SEE THE SPACES BEHIND PROD. IF I ADD A CHAR TO THE STRING LIKE "^" AND LOOK FOR IT, IT WORKS FINE...


Thanks For the help

Brooke