need help in form- move text box value to table_name

[jker]

here is want i want to do...




in my form i want to concatenate the first and last name , then display the concatenate value in a textbox called XLONG
also, when i press a button (ON_CLICK) event. i want the textbox value XLONG moved to the column in my database table.
Column is called CONCAT_NAME

Private Sub Command86_Click()
'XLONG is name of text box on the form'


xlong = CUST_LNAME & " xxxxxxx " & CUST_FNAME & "-" & CUST_INITIAL & "-" & CUST_PHONE & "...." & CUST_CITY




End Sub

[orange]

jker,

Why do you want to save the concatenated value in your table?
Since you store CUST_LNAME and CUST_FNAME..., you can easily create the concatenation when needed.

Where do you plan to use the concatenation?

[Welshgasman]

Don't. Just concatenate it when you need it.

If you insist, just make ConcatName as it's source, so the control is bound.

[moke123]

I agree with Orange and Gasman as to not storing the concatenated value.

It's much more flexible to construct the concatenation on demand. There are some tricks to make it look cleaner.

For example you may have a table with the fields- FirstName, MiddleName, LastName, Suffix.

Using something like -

FirstName & " " & MiddleName & " " & LastName & " " & Suffix

- will work but if the person has no middle name you'll have extra spaces between the first and last name.

To get around the extra spaces you use the fact that a Null plus (+) anything will always be Null.
"A" & Null = "A"
"A" + Null = Null

Note the grouping and uses of the ampersand (a string operator) and the plus sign (a mathematical operator)

(FirstName + " ") & (MiddleName + " ") & (LastName) & (" " + Suffix)

The above will always be properly spaced whether the person has a middle name or not. A Null MiddleName plus a space is Null.

[jker]

i need to store the concatenation in a table so that it can be used by another form.. I want to only do the concatenation once, instead of everytime (which is many times) that i need to use it.

[Welshgasman]

So make a control (hidden if you like) that is bound to the field and set that control.

[jker]

the concatenation has to be a seperate field in the table ........ So i need to concatenate it when i press the SAVE button, and have the concatenation placed into the table column


Can i use some sort of EXPRESSION in the table to do this or do i need to do it at the FORM level?

[jker]

i am new to access so im not sure what you are saying.

i did create a text box with the CONTROL SOURCE BLANK.... and on a CLICK, i call a sub procedure to concatenate the names .
I want the value of XLONG to be put into my table field named CONCAT_LONG

[Welshgasman]

No need for a variable, just set the control to that concatenated string.
You could the code in the button click event.

[moke123]

i need to store the concatenation in a table so that it can be used by another form.. I want to only do the concatenation once, instead of everytime (which is many times) that i need to use it.

Then create a function to return the Concatenated string.

[jker]

sOLUTION HAS BEEN FOUND:

I created an ENTER event for a button, as follows:

Private Sub btnSave_Enter()


CUST_CONCAT_LONG = CUST_LNAME & ", " & CUST_FNAME & " " & CUST_INITIAL & ", " & CUST_PHONE & ", " & CUST_CITY


End Sub

CUST_CONCAT_LONG is a column name in my table . When the SAVE button is pressed, the concatenation happens nd stores results in the database column

[Welshgasman]

So many people think they have to save records in Access, when it does it for you?

[moke123]

Gotta ask. Why are you using the Enter Event of a command button?

Private Sub btnSave_Enter()

Wouldn't the click event be more appropriate?

[Micron]

I guess none of these answers were appreciated, so now double posted
https://www.accessforums.net/showthread.php?t=88639