Default Value

  • Thread starter Thread starter Sash
  • Start date Start date
S

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.
 
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.'
 
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.

KARL DEWEY said:
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


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