I can't set a date from a form textbox in to make table query

[erickfloyd]

I can't set a date from a form textbox in to make table query



I use this: FECHA_INI: [Forms]![VALIDAR PANEL]![Text3]

But when i run the query in the new table the column FECHA_INI looks empty, and i have a date in my form [Text3]

[pbaldy]

Have you hit Enter or Tab after entering the date to commit the value?

[erickfloyd]

yes, bus still blank in new table;

[pbaldy]

Can you attach the db here?

[erickfloyd]

Ups! I don't think so it's 500MB and linked to my system, this is the form when a try to get the date;

[CJ_London]

On the basis you are expecting a date are you sure Text3 is the name of the control next to the label Fecha Inicial and not the one above the actualizar bom button? You would be well advised to give your controls a relevant name - would also help us to help you

It is also likely the field in the new table will be text and not datetime - is this what you require?

[erickfloyd]

Yes I'm really shure that's name is correct for the date textbox and regarding the format in new table a change it in the design make atable query but when a look the new table design appear like binary format

[pbaldy]

Perhaps try wrapping the form reference in the CDate() function?

[erickfloyd]

Woohoo!!! Done!! You rock!!! Thanks!!!

[erickfloyd]

One more thing, they are two more columns still on binary format and I need one as a number and other as a text format, do you know some function to change the format of those?

[pbaldy]

CStr() for text, several others for various numeric data types: CLng(), CDbl(), etc.