var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: first last name button
I am redoing some of my main data and seperating the Customer information into first and last name and then street address in seperate fields.
Right now, I have the field [CustomerName], I'm trying to build a button that, when clicked, will automatically put the first and last name into the corresponding fields:
In a report in the past, I've used the stock code:
but I am having difficulty with the syntax in programming a button to assign these values to new field values.
Thanks in advance for any assitance or advice!
Here's what I'd do:
[CustomerLastName]=Right([CustomerName], Len([CustomerName]) - (InStr([CustomerName], " ")))
[CustomerFirstName]=Left([CustomerName], (InStr([CustomerName], " ") - 1))
Hope this helps!
Thanks for the fix -- I got it working!