Roger Rabbit
|
Posted: 02/18/2001, 12:27 PM |
|
What I want is to make a single field named "FullName" that contains
Trim(LastName) & ", " & Trim(FirstName). Is this possible and if so how
would I do that?
Thanks in advance for any help.
|
|
|
Dante S.
|
Posted: 02/18/2001, 7:06 PM |
|
You can do this via customized SQL SELECT, eg.
SELECT Trim(LastName) & ", " & Trim(FirstName) FullName, address,...etc....
Don't know the exact syntax, but I hope you get the idea.
Regards,
Dante S.
"Roger Rabbit" <rrabbit@bunnyville.com> wrote in message
news:96pb87$4ji$1@news.codecharge.com...
> What I want is to make a single field named "FullName" that contains
> Trim(LastName) & ", " & Trim(FirstName). Is this possible and if so how
> would I do that?
>
> Thanks in advance for any help.
>
>
|
|
|
Alexey Alexapolsky
|
Posted: 02/19/2001, 12:55 AM |
|
Also you can add your own field to a form.
Let's suppose it's name(not caption) is myfield.
Now click Form Properties icon , select "Events" tab ,
select "Show" event. Here you can enter your code that will
run when the form is shown. You can change values of fields right
here , but they must be prefixed with fld . In your case
you must enter code smth like :
fldmyfield = fldfirst_name & " " & fldsecondname ,
or if your lang is different use your own concatenation operator.
--
Regards,
Alexey
CodeCharge Support
Roger Rabbit <rrabbit@bunnyville.com> wrote in message > What I want is to
make a single field named "FullName" that contains
> Trim(LastName) & ", " & Trim(FirstName). Is this possible and if so how
> would I do that?
>
> Thanks in advance for any help.
>
>
|
|
|
Roger Rabbit
|
Posted: 02/20/2001, 3:02 AM |
|
Thanks for the help. I'll try that.
|
|
|
Roger Rabbit
|
Posted: 02/20/2001, 10:36 AM |
|
Alexey;
This works great on update but if I enter a new client I have to update the
record before the FullName field gets filled. I've placed the code in
"Show", "Show on Insert", and "Show on Edit" but it doesn't seem to matter.
The event is not acted upon until I go to the form and click "Update".
Any suggestions would be appreciated.
RR
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:96qn1m$h9n$1@news.codecharge.com...
> Also you can add your own field to a form.
> Let's suppose it's name(not caption) is myfield.
> Now click Form Properties icon , select "Events" tab ,
> select "Show" event. Here you can enter your code that will
> run when the form is shown. You can change values of fields right
> here , but they must be prefixed with fld . In your case
> you must enter code smth like :
> fldmyfield = fldfirst_name & " " & fldsecondname ,
> or if your lang is different use your own concatenation operator.
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
> Roger Rabbit <rrabbit@bunnyville.com> wrote in message > What I want is to
> make a single field named "FullName" that contains
> > Trim(LastName) & ", " & Trim(FirstName). Is this possible and if so how
> > would I do that?
> >
> > Thanks in advance for any help.
> >
> >
>
>
|
|
|
|