table outline

[TjS]

Another question.

One of my tables contains a date/time field format: dd/mm/yyyy;
in the format property of a table column usually (type: text) the indent can be set to left with "!" (without the " of course); however, i would like the date/time column to the left as well in stead of to the right, i can't seem to figure out how to do that.

Please advise
(in this case, my english isn't so good, sorry if you don't understand my question or find it quit cryptical)

 

[rosito]

I cannot understand what u want to do?!?!? Where is the prob?!?!? It is just a table Resize column (with dd/mm/yyyy)

 

[TjS]

problem description advanced

Hi,

i'll try to make the description better:
The position of the information when showing the table in datasheet view is located to the right (outline to the right); however, because the column is used in a rtf file the information has to be outlined the left of the column.

The problem is, that when a table property is not a type: text, but type: date/time that the outline is always to the right.

In other cases (when a table property IS type: text), the outline is to the left, or one is able to force it to the left by putting a ! in the format property of the table column.

However the putting a ! in the format property isn't possible at a column which type is date/time..

If this isn't making anything clear....i will quit and kill my pc....

 

[DJkarl]

Instead of using a datasheet view why not use a query and convert the date field to text? SELECT Cstr([MyDateField]) AS NewField FROM [MyTable]

 

[TjS]

I only use the datasheet view to check the information and how items are being displayed; normal use is that a command button does an output to a rtf file; and this rtf file contains of course the table data; but everything has to be outlined to the left (each column, inclusive the headers...which is - i think - not an option at all though)

Little following question, my date has to be in the format day/month/year (01/12/2007)in stead of the proposed day-month-year (1-12-2007); when converting tot text using cstr, how to change the format? (or is this then only possible by changing the windows settings?)

 

[rosito]

"...when converting tot text using cstr, how to change the format? (or is this then only possible by changing the windows settings?)"...Change it by win settings (with date separator what u want) & use ctrs, then ... i try do all these & export in rtf is oki

 

[TjS]

...Change it by win settings...

i was afraid the answer would be that....it has to be changed on various pc's if that's the case....

Hopefully there will be more suggestions?

 

[Rabbie]

Why not use the Format command.

 

[TjS]

okay, that's an option...only, how to? (sorry...some things i do know, some things i don't...)

 

[TjS]

Outline problem fixed by cstr([date]), but . . .

I want the format of the date to be dd/mm/yyyy, so i entered (i thought it was correct) the column in the query as follows:

cstr(Date([datefield];"dd/mm/yyyy"))

But it doesn't seem to be correct...

please advise?!

 

[TjS]

problem solved!
cSTR(format([datefield]);"dd/mm/yyyy"))

Thanks for all the advise(s)