I am looking at some code written by someone else and I find it strange
looking and confusing. It looks like an assignment coded in reverse.

The statement is:

Mid$(gstrUserRoot, 27,7) = gstrUserId

How should this be interpreted? Thanks.

On Mar 2, 11:56*pm, "Charles Hottel" <chot... (AT) earthlink (DOT) net> wrote:
Hi Charles,

It is the Mid statement, in which you can replace the specified
characters by another value.

Imb.

"imb" <imb4u (AT) onsmail (DOT) nl> wrote

On Mar 2, 11:56 pm, "Charles Hottel" <chot... (AT) earthlink (DOT) net> wrote:
Thanks, but I did know that. Perhaps I can make my question clearer. This
appears to be assiging the value of a variable to a function, but that makes
no sense to me, so I assume that the statement above is equivalent to:

gstrUserId = Mid$(gstrUserRoot, 27,7) which assigns the value of a
function to a variable.

Is that correct? I did not know that the first syntax was legal.

Charles Hottel wrote:

mid(var,4,4) = "l No"
? var
Hell No

It may not be used much (I never have) but it works.

No, the original statement, Mid$(gstrUserRoot, 27,7) = gstrUserId, replaces
the 27th and 6 following characters of the string gstrUserRoot with the
value contained in the string gstrUserID.

Mid (and Mid$) is the name of both a function which extracts data and a
statement which indicates where to save data.

A little sample code and the Immediate Window are your friends in cases like
this.

Larry Linson
Microsoft Office Access MVP

"Charles Hottel" <chottel (AT) earthlink (DOT) net> wrote

Thanks to all who answered.