another stupid question

[jammy_owen]

hi all, this really simple problem is buggin' me so i'll let you lot have a go!

basically, in the datasheet view, how do you separate the title field name into two lines?

ie the field looks like this:
title field 1 title field 2 title field 3 title field 4

but i want it like this:
title title title title
field 1 field 2 field 3 field 4

thanks for your help in advance!

 

[namliam]

You dont

 

[jammy_owen]

yeah, thanks for your help (!)

 

[Mile-O]

Rather than "you don't" - you can't.

You make it sound as if you've confused a datasheet to be like an Excel spreadsheet where Excel cells have the Wordwrap property. Access cells don't have this.

 

[neileg]

If you create a continuous form to display your data you can format the headings anyway you like.

 

[jammy_owen]

oh ok. i just thought this could be done in a table. thanks for all your help