• I modified the code to make sure it would work... so this is a little different than the last version. Should work with strings of any length as long as there's only one \.

    <taking a giant step backward>

    =Right(ReportItems!txtComputerNameUserID.Value,

    Len(ReportItems!txtComputerNameUserID.Value) - InStr(ReportItems!txtComputerNameUserID.Value,"\",Microsoft.VisualBasic.CompareMethod.Text)

    )

    Len(ReportItems!txtComputerNameUserID.Value) --- returns the length of the String.

    InStr(ReportItems!txtComputerNameUserID.Value,"\",Microsoft.VisualBasic.CompareMethod.Text) -- returns the ordinal position of the "\" in the string.

    Subtracting the two leaves the length of the string after the

    So the RIGHT(string, length) part returns the part of the string to the right of the \.

    Does that make sense?