Extracting Part of a Field

[Guest]

Hello All,
I am trying to set a statement to set the default value of one text box with
the last 7 digits of another. For example in field account code box the
following is diplayed: 1234567890. In the tracking code box I want, 4567890
to be the default value. I know where to put it, just not sure of the synax.
Many Thanks, Adam

 

[Joseph Meehan]

It is a number type field or a text field?

 

[Guest]

Hi - Use the Right function: Right([Account Code], 7)

 

[Guest]

Hi.

According to Access Help, the Default Value is "a value that is
automatically entered in a field when a new record is created." I don't
think this is what you want, because when a new record is created, the Field
Account Code box would be blank.

I think what you want here is an unbound text box, for which the Control
Source should be set to:
=Right([FieldName],7)
where "FieldName" is the name of your Field Account Code control.

-Michael