Changing a field display

[Guest]

Hello all,

Hopefully this is an easy question. I have a account field, all accounts
have an X in front of them (ex. X4987). On my report I would like to display
the number without the X. Is this possible? Thanks!

James O'Donnell

 

[Duane Hookom]

If all accounts have an "X" as the first character, you can use:
Mid([AccountField],2)

 

[Marshall Barton]

Hopefully this is an easy question. I have a account field, all accounts
have an X in front of them (ex. X4987). On my report I would like to display
the number without the X. Is this possible?

Set the text box's control source expression to:

=Mid(accountfield, 2)

Note that it is critical that the text box's name be
different from the field name (e.g txtaccountfield)

 

[Guest]

Thanks to both of you. Worked like a charm!

Set the text box's control source expression to:

=Mid(accountfield, 2)

Note that it is critical that the text box's name be
different from the field name (e.g txtaccountfield)