Default Value

[Sash]

I have a form and I'm trying to make the default value of one field equal to
a combination of two other fields. On the Data properties of CMD field, I
have the following on Default Value:

=([RevCtr]) & Right([SimItem], 4)

Why isn't this working? All fields are text fields.

 

[KARL DEWEY]

It is difficult to say with out knowing what you are geeting as a result.
I assume that RevCtr and SimItem are field names.
Give an example of the data in them and what you get that 'isn't working.'

 

[Sash]

Yes they are fields.

Example:
RevCtr 234
SimItem 12345

Result I want:
2342345

However, the field remains blank. It's not displaying anything. I do
something similar on a different form and it works perfed.

It is difficult to say with out knowing what you are geeting as a result.
I assume that RevCtr and SimItem are field names.
Give an example of the data in them and what you get that 'isn't working.'
--
KARL DEWEY
Build a little - Test a little

I have a form and I'm trying to make the default value of one field equal to
a combination of two other fields. On the Data properties of CMD field, I
have the following on Default Value:

=([RevCtr]) & Right([SimItem], 4)

Why isn't this working? All fields are text fields.

 

[Ryan]

Try this.
=([RevCtr]) &""& Right([SimItem],4)