Change columns headers size in table

[jaryszek]

Hi ,

how big can be length of columns header size?

I have header name:

"orzeczenie o stopniu niepłnosprawności lub orzeczenie lekarza orzecznika ZUS" and it can't be created as header because the name is too long.

It is possible to change it? Or i have to shorten my header?

Please help,
Jacek Antek

 

[Uncle Gizmo]

Why do you need such a long header?

Sent from my SM-G925F using Tapatalk

 

[jaryszek]

It is need from my client. It is possible to resize lenght of column header?

 

[JHB]

The max numbers of characters in a field name is 64 and can't be changes.
http://webcheatsheet.com/sql/access_specification.php

 

[Uncle Gizmo]

It is need from my client. It is possible to resize lenght of column header?

That's not helpful in the context of getting an answer to your question. You need to provide a better explanation of what you are trying to do.

 

[jaryszek]

Im trying to do "CREATE TABLE" statement and make text
"orzeczenie o stopniu niepłnosprawności lub orzeczenie lekarza orzecznika ZUS" as column header.

JAcek

 

[Uncle Gizmo]

Im trying to do "CREATE TABLE" statement and make text
"orzeczenie o stopniu niepłnosprawności lub orzeczenie lekarza orzecznika ZUS" as column header.

JAcek

Yes I understand, and you are receiving an error because the text is too long?

 

[jaryszek]

exactly.

Jacek

 

[Uncle Gizmo]

Yes I understand, and you are receiving an error because the text is too long?

Therefore you are not going to be able to continue in the way you want. You need an alternative. If you explain what you are trying to do then you might get some suggestions. Otherwise there's nothing further to say.

 

[jaryszek]

Ok so answer is NO, you can't change lenght of column header.

Hmm I have big Excel table with 54 headers. And some of these headers are too long for Accesc database. I see one solution: shorten columns headers.

Jacek

 

[Uncle Gizmo]

I see one solution: shorten columns headers.

Have you considered linking to the Excel spreadsheet instead of moving it into MS Access?

 

[stopher]

Ok so answer is NO, you can't change lenght of column header.

Hmm I have big Excel table with 54 headers. And some of these headers are too long for Accesc database. I see one solution: shorten columns headers.

Jacek

Yes I'd shorten (or create my own) headers. Long field names aren't at all practical. Furthermore, you'll have all sorts of undesirable characters to contend with e.g space. Field names should not have spaces etc.

But you can use the fields Caption attribute to store the long name. This will appear by default in query headers and on forms and reports. The client should not need to see the table names in any case.

 

[jaryszek]

No because there is a lot of small excels and from each one i create table to access and this is done in real time

thank you for your tip

Jacek

 

[jaryszek]

Stopher,

thank you,

what is fields caption attribute?
I can't see in my access table this.

Jacek

 

[stopher]

Stopher,

thank you,

what is fields caption attribute?
I can't see in my access table this.

Jacek

Go into table design view. Then click on a field. You should see all the attributes for that field including "Caption".

 

[jaryszek]

Ok thank you. I get it.

But i have to do 2 things connected with this:

1. create captions using adodb connection
2. if i have table in access - i have to write query to download table with captions insted of normal headers.

I do not know if this possible.

JAcek

 

[gemma-the-husky]

why would you possibly need your text as a field name?

 

[jaryszek]

Because in Excel my text is a field name, this is a kind of Polish document,

Jacek