Recent content by ahg

Thanx Missinglinq, but it doesn't quite work. If you have say 3.5 lines in a label box, selecting Distribute will justify all lines including the fourth half line which will become stretched out of proportion.

As in MS WORD, Align Left, Align Right, Centre or Justify. Justify, i.e. space words in a line so the line aligns both left and right. AHG

Is it possible to justify the text within an Access 2000 label? It seems I can left, right and center the text - but not justify. Appreciate any help. AHG

Thanks folks, My BIOS was updated. I did replace the cable but it didn't seem to make any difference. Phoned Maxtor but they could offer nothing more than a possible cable problem. (But I have heard that it could be a HDD controller problem.) Anyway I'll try a new cable again. Thanx again AHG

Not sure whether this is a Win XP (Pro) problem or not but... When I start my computer in the morning everything will work fine. Next morning I start again and it doesn't recognise my 80GB Maxtor hard drive and asks to insert boot disk. I restart (either reboot or shut down then restart -...

Randy, I ended up using VBA - and it works fine. Many thanks for your help. AHG

Thanks Randy - again, Yes, I would appreciate seeing an example of the VBA coding. AHG

Thanks Randy, but the field is not on the form at the moment. No reason why it shouldn't be I suppose in which case it is probably a simpler approach. I will check it out and get back to you. Thanks for your assistance. AHG

I have a lookup table which contains one date field. I want to update (change) this date to Now() when I click a button on a form. Can anyone please show me the code required to update this date field? Many thanks in anticipation. AHG

If you press Alt + down arrow when the cursor is in the combo it will drop down. An alternate is to use Sendkeys "%"{down} in the On Enter event to drop the combo automatically when you enter.

Thanks all for your help - only goes to show the flexibility of Access and VB! Tony

Many thanks Daniel, That works great - so simple, yet elegant! Tony

Again, many thanks - but when I apply this I get the date Oct-31-321 instead of Oct-31-2002. Where would I be going wrong?

Thanks, but not sure how to write this so that when I select the check box today (on Nov 17th) the field I wish to set the date in will read October 31st? Thank again. I know it sounds easy but confusion reigneth!

I have a date field that I want to set to display the last day of the previous month when I select a check box. Can anyone give me the code for this please? Many thanks in advance, Tony