space

[Guest]

hi , plz help
i have made a data, and i have 3 field "name" & " City" and "fullname"

how can i make text box like this,
Param
Kaur

i mean in same field what sprit show,

 

[John W. Vinson]

hi , plz help
i have made a data, and i have 3 field "name" & " City" and "fullname"

how can i make text box like this,
Param
Kaur

i mean in same field what sprit show,

I don't know if Param is a name, or a city, nor do I know what "fullname" has
to do with it... but you can set the Control Source property of a textbox to

=[Name] & Chr(13) & Chr(10) & [City]

to show Name on one line and City on the next line.

Note that Name is a bad choice of name for a field or control - *everything*
in Access has a Name property, and Access will get confused whether you mean
the value of the field whose Name is Name, or the Name of the textbox
containing Name... and if you think this sentence is confusing, you're right!

John W. Vinson [MVP]

 

[Guest]

Thank you john for your reply, i really apericate for your time.

I have made a client database, but i need help to set a field like this for
example some client have long name some have short name so i am looking fo r
a code so when i print a letter so the and address comes in right line and
coloum something like this,
Mr Rob Smith
28 West Green Avenue
Derby
DE 24 9AQ

and also is there any way to set a data to pick only clients first intial so
we can print a differently.

Many Thanks

 

[John W. Vinson]

Thank you john for your reply, i really apericate for your time.

I have made a client database, but i need help to set a field like this for
example some client have long name some have short name so i am looking fo r
a code so when i print a letter so the and address comes in right line and
coloum something like this,
Mr Rob Smith
28 West Green Avenue
Derby
DE 24 9AQ

and also is there any way to set a data to pick only clients first intial so
we can print a differently.

You should certainly have your names and addresses broken down into separate
fields: [Title], [Surname], [Forename], [Address], [City], [Postcode] for
example. You can create a Report with textboxes; for example you could get the
above with four textboxes with control sources

= [Title] & " " & [forename] & " " & [Surname]
= [Address] <<< or you might split addess up further
= [City]
= [Postcode]

You could get the initial using

= Left([Forename], 1) & ". " & [Surname]

to display

R. Smith


John W. Vinson [MVP]

 

[Guest]

Thank you for your reply , thanks for your help, i have got a new question
for you I have made a report which is working perfectly fine I wonder how can
i bold same field in the same text box.

param

 

[John W. Vinson]

Thank you for your reply , thanks for your help, i have got a new question
for you I have made a report which is working perfectly fine I wonder how can
i bold same field in the same text box.

param

Access doesn't have any builtin ability to display some text and not other
text in a single textbox. You can either use separate textboxes, or a "Rich
Text Format" control.

John W. Vinson [MVP]