is there a better code for removing the first character??

[n8kindt]

this is what i have:

Right$([Var],(Len([Var])-1))

it works but i'm just curious... is there a built-in function that is better than this?

[Stewart Ross]

No, there is no built-in which removes just the first character.

Right$, Left$ and Mid$ are generalised to be able to remove 1, 2 ... N characters as needed, and like all built-ins are intended to have wide applicability, which would not be the case for a function removing just one character.

Whatever 'better' might mean in the context of string functions such as these, your Right$ version is fine as it is.

-Stewart

[ADezii]

this is what i have:

Right$([Var],(Len([Var])-1))

it works but i'm just curious... is there a built-in function that is better than this?

How about shorter?

Mid$([Var], 2)

[n8kindt]

How about shorter?

Mid$([Var], 2)

perfect! yes that will definitely work. thank you, ADezii. i found that using this code in an unbound textbox with this code refreshes nearly instantaneously while my code took about 1 second to update. i didn't think it would make that much difference but it certainly did!

cheers,
nate

[ADezii]

perfect! yes that will definitely work. thank you, ADezii. i found that using this code in an unbound textbox with this code refreshes nearly instantaneously while my code took about 1 second to update. i didn't think it would make that much difference but it certainly did!

cheers,
nate

You are using 1 Function (Mid$) as opposed to 2 (Right$, Len) but I honestly thought the difference would be insignificant, that's why I didn't even mention it.

[NeoPa]

Likewise I didn't consider the performance advantage when I looked to find ADezii had got there before me ;)

I would guess that Mid() would be quicker as it doesn't have to process the whole string before it starts to extract the required part as Right() does.

At least that's what I was going to say before considering that VBA stores strings with a preceeding length element as opposed to the way C does it with a trailing NullChar. This would rather indicate that either method should be instantaneous.

[n8kindt]

At least that's what I was going to say before considering that VBA stores strings with a preceeding length element as opposed to the way C does it with a trailing NullChar. This would rather indicate that either method should be instantaneous.

you're right, Neo. i just realized i was placing Nz() around the variable in my function which slowed it down. once i did the same with the new function, it calculated at the same speed. i prefer the new one however since it is less work to sort thru in order to debug, replace variables, etc..

[NeoPa]

Oh me too, certainly Nate :)