Search results

I have never used one of these before and need to create which can search from one or a number of facts, is this possible? if so how? really stuggling here so if someone wants to take pity and help, i would be most greatful Many thanks Nick

cheers for that fella, got it sorted :) :) When using this one, if i have a caption set in the table, do i use the caption or field heading, or a combo of both if so, which order? If Not IsNull(Me.MyTextBox) Then _ Me.MyTextBox = StrConv(Me.MyTextBox, vbProperCase)

Rite, took some advice, seperated out first name sur name etc and anything else which was of such a rubiish design (this design was given by lecturer!!!) But i still want to make the start of each word, appear in capitals within the tables, even if input in lower case. eg. dog should appear...

I mite be being really stupid, but I can't find an on update option in the properties of a table, a Form I can, but everything needs to be done in a Table. Am i being blind help if you can please thanks nick

to do this do i need to write a macro, or can it go in as some kind of vlaidation?

Hi I'm new round here, and just wondering if anyone could shed some light on a few issues which I am trying to resolve in Access 2000. Is it possible to make each word start with a capital letter even if the user inputs all the text in lower case, for example: user inputs: john smith Desired...