Display via an expression

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

Guest

Hi, still new to all of this. Simple question I'm sure. I have an account
number that is approx. 9 digits long, however I want to write an expression
to show me only the last 4 digits of that 9 diget account #.

How do I do this...........
 
Renetta

Check Access HELP re: the Right() function. Your expression will look
something like:

Right([YourFieldName],4)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi, still new to all of this. Simple question I'm sure. I have an account
number that is approx. 9 digits long, however I want to write an expression
to show me only the last 4 digits of that 9 diget account #.

How do I do this...........
Click to expand...

Use an unbound text control for this.
Set it's control source to:
=Right([FieldName],4)
Make sure the name of this control is NOT [FieldName].
 
Back
Top