Display part of field on a bound form using the RIGHT function???

[INeedAccessHelp]

I have the control source of the field on the form set to:

=Right(

, 8)

and it displays "#Error"

If I use:

Right([Code], 8)

I get "#Name?"

Any ideas what I'm doing wrong?

 

[INeedAccessHelp]

Not sure what happened to my post but, the functions should read:

=Right(

, 8)
&
Right([Code], 8)

 

[INeedAccessHelp]

For some reason, this isn't working.

Before the comma in both examples, I have the table's field name enclosed in brackets.

 

[jjonesal]

Try creating a new unbound control and for that control using a control source of:

=right(controla,8)

(where controla is your original field)

Or you could create a calculated field in your query that does the same thing and then just include this field on the form.

J. Jones
jjones@cybrtyme.com