Can I add characters to a field on Add New Record?

[msreed]

I want to populate a field in a table from a field on my form but I want to add to the data, is that posible? For example, the BillNo on my form reads: 2000031039134MAP, I want it to populate with: 2000031039134MAPR. I tried the following but neither one of them worked. Any help would be appreciated.

rstAddNew
rstHeaders![BillNo] = Me![txtBillNo] AND "R"
rstHeaders![BillNo]= " Me![txtBillNo] AND R "

 

[cghoga]

try this...

rstHeaders![BillNo] = Me![txtBillNo] & "R"

 

[msreed]

Yes, the record added the R to the BillNo, but with a space in between the two. Is there a way I can get rid of that?

 

[cghoga]

i'm not saying the code i gave you is infallible, but did you check to make sure there weren't any blank spaces at the end of the field before the concatenation took place?

try this...

rstHeaders![BillNo] = RTrim(Me![txtBillNo]) & "R"

hope this helps you.

 

[msreed]

The trim function worked, thank you for your help!