display part of result

R

Russ

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,
 
F

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,
Click to expand...

=Mid([SomeString],5)
 
N

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,
Click to expand...

=Mid([SomeString],5)
Click to expand...
 
N

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,
Click to expand...

=Mid([SomeString],5)
Click to expand...
 
Top