How to hide a character in a field?

[just2cool]

I have a field which looks like this - "d123456", I will have to display the field without the "d" in front, meaning I will need to show "123456" Any idea how I can do this? Thanks!

 

[Michael J Ross]

If the field is always the same length then use

Right([nameofyourfield],6)

 

[just2cool]

Thanks for your reply.
But the number of characters in the field varies. Sometimes it is d123 sometimes it can be d12345, etc.

 

[MStef]

Try this:

Right ([FieldName],(Len([FieldName] - 1)))

 

[just2cool]

This one worked

Right([Orig],Len([Orig])-1)

Thanks!!