okeyuzosike
Programmer
Good morning everyone,
Please I need your assistance. I generated an excel spreadsheet (report) from access file. I have the report headings in Cell (A5) all the way accross to Cell(Q5). I mean, each cell, starting from A5 through Q5 contains the entire 17 headings(fields). On display, the headings looks like this:
N|
A|
M|
E|
instead of displaying like this:
"NAME".
Note: This also affects other fields that has big chunk of characters, like in the "description" field.
I have tried doing: "WS.UsedRange.MergeCells = True", but it was giving me a message that only the upper leftside data will be displayed.
How can I do a global adjustment to either the cells or rows to display normally?
Thank you.
Okey.
Please I need your assistance. I generated an excel spreadsheet (report) from access file. I have the report headings in Cell (A5) all the way accross to Cell(Q5). I mean, each cell, starting from A5 through Q5 contains the entire 17 headings(fields). On display, the headings looks like this:
N|
A|
M|
E|
instead of displaying like this:
"NAME".
Note: This also affects other fields that has big chunk of characters, like in the "description" field.
I have tried doing: "WS.UsedRange.MergeCells = True", but it was giving me a message that only the upper leftside data will be displayed.
How can I do a global adjustment to either the cells or rows to display normally?
Thank you.
Okey.