Hi People

I need help!!!

Have got a excel file that i have put into an access file so that i can
create a mailing carrier sheet without re typing everybodys details in.

The excel file has some blank spaces within it for example:

Mr A Smith
Headteacher
The School
Lincoln
LN1 1UY

and

Mr B Smith

The School
Lincoln
LN1 1UY

How can i get the database to not show the blank spaces, and move the
details up 1 line.

I have created the mailing using the report method on access and cannot
see how to fill in the blanks.

Do i need a bit of code? - If so how do i create it?

Your help would be much appreciated.

Tris n Ady

"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140510480.485648.164950@g43g2000cwa.googlegr oups.com...[color=blue]
> Hi People
>
> I need help!!!
>
> Have got a excel file that i have put into an access file so that i can
> create a mailing carrier sheet without re typing everybodys details in.
>
> The excel file has some blank spaces within it for example:
>
> Mr A Smith
> Headteacher
> The School
> Lincoln
> LN1 1UY
>
> and
>
> Mr B Smith
>
> The School
> Lincoln
> LN1 1UY
>
> How can i get the database to not show the blank spaces, and move the
> details up 1 line.
>
> I have created the mailing using the report method on access and cannot
> see how to fill in the blanks.
>
> Do i need a bit of code? - If so how do i create it?
>
> Your help would be much appreciated.
>
> Tris n Ady[/color]


I guess you have a field called JobTitle or something which is not filled in
for all people. In the design view of the report, highlight this textbox
and press F4 to show the properties. On the first tab labelled 'Format'
change the CanShrink property to Yes. This should cause it to shrink
completely when the field is blank.

Hi

Thats Brillant Thankyou, However

When doing this it looks like I have extra spacing after the lines
which contain no information

Is there a way of reducing this space so that it matches the rest of
the line spacing, I have no borders selected or any thing else that
seems obvious?!

Many Thanks

Tris n Ady

"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140514276.287089.52430@z14g2000cwz.googlegro ups.com...[color=blue]
> Hi
>
> Thats Brillant Thankyou, However
>
> When doing this it looks like I have extra spacing after the lines
> which contain no information
>
> Is there a way of reducing this space so that it matches the rest of
> the line spacing, I have no borders selected or any thing else that
> seems obvious?!
>
> Many Thanks
>
> Tris n Ady[/color]



If you were printing labels, for example, then you would want the height to
remain constant because you need to start printing the details at exactly
the same position on each label.
I'm not sure I completely understand, but I think you are saying that you
don't want this, but want the height taken by each entry to vary.
If that is the case, set the CanShrink property of the report's detail
section to Yes - this is 'the white space behind your textboxes'.

Hi Again!

The shrink option is working but we are recieving more line space in
the fields that are blank.

i.e

Mr Smith
Headteacher
The School
Lincoln

(This is because he has a job title)

and

Mr Smith

The School
Lincoln

We have managed to close the gap up a little by selecting the can
shrink option but we want it to look like it follows on, ie on three
lines not three lines and a blank line space.

Cheers

Tris n Ady

"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140515446.652810.175390@g43g2000cwa.googlegr oups.com...[color=blue]
> Hi Again!
>
> The shrink option is working but we are recieving more line space in
> the fields that are blank.
>
> i.e
>
> Mr Smith
> Headteacher
> The School
> Lincoln
>
> (This is because he has a job title)
>
> and
>
> Mr Smith
>
> The School
> Lincoln
>
> We have managed to close the gap up a little by selecting the can
> shrink option but we want it to look like it follows on, ie on three
> lines not three lines and a blank line space.
>
> Cheers
>
> Tris n Ady[/color]



And you have set CanShrink for the textboxes and the report's detail
section? If you still can't get it to work, post back and I'll send you an
e-mail address you can send it to if it's nothing too confidential.

Hi

I have checked these and they are already checked.

I still cant get it to work.

I cannot send the file to you, however I have created a small made up
database and am happy to send that for you to have a look at.

If possible can you provide me with your email address so i can forward
this on to you.

Many Thanks

Tris n Ady

"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140522242.100484.57160@f14g2000cwb.googlegro ups.com...[color=blue]
>
> Hi
>
> I have checked these and they are already checked.
>
> I still cant get it to work.
>
> I cannot send the file to you, however I have created a small made up
> database and am happy to send that for you to have a look at.
>
> If possible can you provide me with your email address so i can forward
> this on to you.
>
> Many Thanks
>
> Tris n Ady[/color]



I've sent the details to yours assuming you provide a valid e-mail - I don't
post one here.

Hi

Many Thanks for that

However I have just done it!!!

My problem was that my boxes which contained the fields were slightly
over lapping each other!!!! I have made all these so they now do not
touch and the results are brillant.

I will read your reply to my email any way but just want to say many
thanks for the help!!!

Our Previous data bases were some what destroyed by a member of staff
who recently was made redundant!!!!!!

Cheers Again

Tris and Ady

Glad to hear you got it sorted!



"Tris" <tristanpalser@yahoo.co.uk> wrote in message
news:1140525017.918960.86590@o13g2000cwo.googlegro ups.com...[color=blue]
> Hi
>
> Many Thanks for that
>
> However I have just done it!!!
>
> My problem was that my boxes which contained the fields were slightly
> over lapping each other!!!! I have made all these so they now do not
> touch and the results are brillant.
>
> I will read your reply to my email any way but just want to say many
> thanks for the help!!!
>
> Our Previous data bases were some what destroyed by a member of staff
> who recently was made redundant!!!!!!
>
> Cheers Again
>
> Tris and Ady
>[/color]