Hi

Title says it all really - I have a column in the table that I previously typed a string into, and now I want the value to be null (preferably via a key, rather than having to write SQL to do it).

Typing the word "Null" doesn't do it (it's a string field so I'm not sure how to do this.

In a similar vein, I seem to remember there was a keystroke you could use to automatically fill a date field with the current date - Can anyone tell me what that is please.

Cheers
Shane

Greetings Shane

I missed your post and you may have already worked it out.

<<Typing the word "Null" doesn't do it (it's a string field so I'm not sure how to do this.>>

If you right-click in the field, the menu gives an option to "Set as Null".

<<In a similar vein, I seem to remember there was a keystroke you could use to automatically fill a date field with the current date - Can anyone tell me what that is please.>>

Similarly, you can set Current Date, Current Time or Current Timestamp by right clicking in the field and selecting the appropriate option.

<ctrl> <alt> N, <ctrl> <alt> D, <ctrl> <alt> T, <ctrl> <alt> S sets the field to null, the current date, current time and current timestamp.

You can also set the default value of the fields to be CURRENT_DATE(), CURRENT_TIME() or CURRENT_TIMESTAMP().

Richard