how can Two text box as one input

[bigbigi]

can you guys help me plz....
for example
two text box
one is "frist name"
one is "last name"

how can two input megre into one input in the column "name"

another question is
how can i use the bullet point as data entry
for example
two choose for Male and Female

 

[Luddite Lad]

You will need a third unbound TextBox in the control source for that text box put the following;

=[frist name] & " " & [last name]

You might want to think about renaming your fields to not include a spaces, to say FirstName or First_Name.

The way I have used bullet points or symbols is to store them in a specific table, for example in your case TBL_Gender and paste the required symbol into the appropriate record in the table. I then use a ComboBox to select the symbol the font name in the format tab for the ComboBox must be set to the appropriate font to display the symbol correctly. When you paste the symbol into your table it will probably not appear as you expect when you view it in the table, it will however display correctly in the ComboBox if you have set the font name correctly.

Check the attached DB

 

[bigbigi]

thz for that very much

 

[boblarson]

Just another comment - I would NOT store them as one name. It is easy to concatenate them in a query at the time you need it, but it is hard to pull them apart, especially if you don't have the parts stored separately. If you DO have them stored separately, but are going to store the concatenated version, then realize you are violating normalization rules (which you can do, of course) and that can take more to maintain than if you just concatenate values at runtime. For example, what if you have a name change for someone (say for marriage). You would then have to go update in two places if you are storing the two values and the concatenated value. If you are not storing the two values, then the headache can happen if you have someone with the last name of, say - Van Buren which then becomes a night mare to try to split the two fields apart.

 

[Luddite Lad]

In addition if you store first and last name separately it gives you a whole lot more flexibility as to how the names can be display and used on forms or reports, that you would loose if you stored them in one field.

For example if you had the name Kym Byrnes it could also be displayed as Byrnes, K or Byrnes, Kym or K. Byrnes or even Kym B. depending on how you chose to concatenate and or trim the fields.

 

[bigbigi]

may the example is not good enough...
actually mine one is ID card number
say A1000 and the ID only got type "A" , "B" and "Z"
i want to have a combo box for to input the prefix letter
and a text box for the number....

another question is that if i choose "A" in that combo box
how can i put a prefix in another text filed
say i chose "A" "1000" in ID card 's combo box and field
how can i make the prefix of team no below is "axe" inside that text box??
again
thz for that~~

 

[Banana]

You can use input mask to control how ID can be entered. Search on "input masks" for more details.

I had difficulty understanding your second question... Are you asking how to get the second combobox to display choices such as "axe" if the prefix "A" is selected? If so, search on cascading comoboxes.

 

[missinglinq]

Isn't it great when the question posed by the OP is not actually the OP's question?

 

[bigbigi]

You can use input mask to control how ID can be entered. Search on "input masks" for more details.

I had difficulty understanding your second question... Are you asking how to get the second combobox to display choices such as "axe" if the prefix "A" is selected? If so, search on cascading comoboxes.

sorry for my suck english...
what i mean is
when i chose "A" in the combo box
the the another text box will have a prefix in it...
say if i chose "A" in the combo box for ID card number
the prefix "axe" will appear in the text box of team number