Search results

I am creating a field in a report query where I wish to form the string result to appear as several lines in a report field. eg. multiline: ([field1]&Chr(10)&[field2]) I just get a square block character showing in the report field. Is it possible to do this ?? (Reason for the expression is...

I have a lot of query fields that I need to compare in a function that I call as part of an expression in a db query column. I am wondering if it is possible to pass the entire row to the vb function (or can it somehow be accessed) ? This is what i'd like to do (if this was the right...

Depending on flags in each incoming database row I'd like to be able to assemble descriptive text alongside other columns taken directly from the database row. Is it possible to intercept the assembly of each listbox row, and insert the descriptive text ? "Department Head" | Joe Ninety |...

I have four pages on a tab sheet, each page has its own combo box that has its own rowsource query. When I open the form each page's combo box value is 'null' until I make a selection. How do I get each combo box to show 'the first' row in its box, ie have the first row as its value ? I've...

My first post, and hopefully a useful one ! I have a combo-box (Combo50) in my form that has its own RowSource query. [Combo50].Value correctly gives me '2' which is the record id of my selection, but I want to pick up the text of the field that's shown which is 'Prospect'. Can I simply...