Changing a field display

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
If all accounts have an "X" as the first character, you can use:
Mid([AccountField],2)
 
James said:
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?
Click to expand...


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)
 
Thanks to both of you. Worked like a charm!

Marshall Barton said:
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)
Click to expand...
 
Back
Top