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!

You dont

yeah, thanks for your help (!)

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

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.

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

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