display part of result

[Guest]

i have a combo field that uses DLookup to set its defautl. the problem is it
returns 1 of 4 values, all start with the 4 letters "Site..."

ie the results could be SiteLower, SiteUpper, SiteDown, siteBack

is there a code to eliminate the first 4 letters of the result? so it would
only return Lower, Upper, Down or Back.

thanks,

 

[fredg]

i have a combo field that uses DLookup to set its defautl. the problem is it
returns 1 of 4 values, all start with the 4 letters "Site..."

ie the results could be SiteLower, SiteUpper, SiteDown, siteBack

is there a code to eliminate the first 4 letters of the result? so it would
only return Lower, Upper, Down or Back.

thanks,

=Mid([SomeString],5)

 

[Naeem Azizian]

use this:
right(len(DLOOKUP())-4,DLOOKUP())

in DLOOKUP() put your complete DLOOKUP function

4= equal to number of letters in SITE

i have a combo field that uses DLookup to set its defautl. the problem is it
returns 1 of 4 values, all start with the 4 letters "Site..."

ie the results could be SiteLower, SiteUpper, SiteDown, siteBack

is there a code to eliminate the first 4 letters of the result? so it would
only return Lower, Upper, Down or Back.

thanks,

=Mid([SomeString],5)

 

[Naeem Azizian]

use this:
right(DLOOKUP(),len(DLOOKUP())-4)

in DLOOKUP() put your complete DLOOKUP function

4= equal to number of letters in SITE

i have a combo field that uses DLookup to set its defautl. the problem is it
returns 1 of 4 values, all start with the 4 letters "Site..."

ie the results could be SiteLower, SiteUpper, SiteDown, siteBack

is there a code to eliminate the first 4 letters of the result? so it would
only return Lower, Upper, Down or Back.

thanks,

=Mid([SomeString],5)