I am trying to use SetValue in a macro. I have the macro set up and it works fine if I go from a date field to a date field.
I want to pass values from several fields concatenated with other fields into a notes field.
For example:
forms.form1.RentalCreditPercent & "for a total of" & forms.form1.CreditDays
So RentalCreditPercent is a number field (percent)
Credit days is a General Number field
I have tried Str(forms.form1.CreditDays) but that doesnt work