Return Partial String

[TLW]

I am attempting to return partial text string from a field in which the data size is not constant. I have "D010 BlueHaze X_Int". In this string, Blue Haze can be any name in the field specified by the user such as AlligatorSnowCones or Green. How can I return this partial text string. I need to display all characters starting on the 5th space from the left and ending on the 6th space from the right. Any help would be greatly appreciated.

 

[joeyreyma]

try:

PartialString = Mid$(MainString,5,Len(MainString) - (5+4))

 

[TLW]

Thanks, that that expression coupled with an IIF statement gave me exactly what I needed.