15,867,453 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Rob Branaghan (Top 134 by date)
Rob Branaghan
24-Feb-16 6:08am
View
Are you writing this program as a Console Program or a Win Forms program?
Rob Branaghan
24-Feb-16 6:06am
View
Hi, Looking at your code you are not using the Master Page correctly.
If you add a master page to your project, and then add a new page (using Master page) select your new master page, and paste the code into a content placeholder and try that.
Rob Branaghan
23-Dec-15 6:25am
View
Is the table users_login using TheAttempts as a varchar and not using an int? Because at a guess if theVal == "one", does that mean you have the same code except for setting "TheAttempts" to be "two"?
Also, it would be best to use "Using" Sql Connection and Command, otherwise you will have an open connection.
Rob Branaghan
4-Nov-14 7:03am
View
Are you populating your combobox dynamically?
If you have then I think you want to look at SelectedItem, rather than value?
Rob Branaghan
4-Nov-14 7:01am
View
What background code do you have? (The Default.aspx.cs file)
Because you will probably have some code for when the text has changed in the txtCustomer?
Rob Branaghan
7-Oct-14 6:56am
View
Please use Stored procedures! Because that will help you a whole lot more in not being injected! also, can you post the FillGrid code? Or if it would be easier, all code for that page (front end and c#)
Rob Branaghan
6-Oct-14 8:00am
View
Deleted
Do you have only 1 teacher per course?
Rob Branaghan
6-Oct-14 6:51am
View
A little more info please.
Perhaps some example data as well?
if you could post Column Names, Types, ID fields.
Rob Branaghan
23-Jun-14 17:03pm
View
At which part of your code triggers error.
Also, if this is COM, are you marshaling the COM object when you finish using it?
Rob Branaghan
23-Jun-14 16:54pm
View
Hi, So you are wanting to tell ws1 that it is a specific sheet by name?
Rob Branaghan
17-Jun-13 4:19am
View
Do you have access to the stored procedures that write to the database?
Rob Branaghan
17-Jun-13 4:10am
View
Your welcome!! Which method did you go with out of curiosity?
Rob Branaghan
5-Feb-13 4:27am
View
That last bit in the where clause is a little confusing, why aren't you just using Year(EC.call_date) >= @from_year AND MONTH(EC.call_date) >= @from_month?
Rob Branaghan
4-Feb-13 4:01am
View
There appears to be some missing... There is an OR, but nothing more.
Rob Branaghan
1-Feb-13 4:11am
View
Would it be possible to see the SQL, as it would be a lot easier to assist being able to see the SQL.
Rob Branaghan
1-Feb-13 4:09am
View
Dont use views. Views are slow....very slow....
You may perhaps want to try the Actual Execution Plan, so you can see what part of the query is taking the longest, and then you may have to add another index to the table, or switch the main table to a different table in the query.
Rob Branaghan
28-Jan-13 9:30am
View
I think its because your grouping by on your Select statement, and you're not bringing back the sno field in your select statement.
I dont quite understand what you are trying to do with this data. Why are you grouping?
Rob Branaghan
25-Jan-13 4:44am
View
I always use stored procedures for everything, makes future upgrades easier!
With regards to the hack, have you made sure you have changed the passwords on the database, checked for users security on the database that you did not add?
Rob Branaghan
25-Jan-13 4:38am
View
See edited code above
Rob Branaghan
25-Jan-13 4:38am
View
You're welcome
Rob Branaghan
17-Dec-12 9:39am
View
Sorry miss reading your post.
Rob Branaghan
17-Dec-12 9:24am
View
Can you set the tag of the literal control?
Rob Branaghan
6-Dec-12 8:45am
View
So you want to delete from the table where the field contains a 7?
Rob Branaghan
5-Dec-12 9:53am
View
Thank you Marcus :)
Rob Branaghan
23-Nov-12 5:10am
View
Do you have a lot of data in the database?
Reason I ask is due to the express versions only using 1gb ram even if more exists.
Rob Branaghan
22-Nov-12 6:02am
View
No worries, Glad I could help.... Good luck with the rest of it :)
Rob Branaghan
22-Nov-12 5:53am
View
Is it a List<string> or is it List<YourObjectType>?
Rob Branaghan
22-Nov-12 5:36am
View
Did my original Solution work for you in the end?
Rob Branaghan
20-Nov-12 9:00am
View
No problem! Did it work to how you wanted?
Rob Branaghan
20-Nov-12 4:36am
View
On my base forms I have 3 buttons on mine, but I guess you dont have to have any controls there, just the Background image.
Rob Branaghan
19-Nov-12 10:37am
View
Can you post more of the code?
As it is looking like you are missing the closing tag for WizardSteps.
Rob Branaghan
16-Nov-12 9:49am
View
Do you mean that when you are in Edit Mode, when you enter data, it is not formatted? Is that what you mean?
Rob Branaghan
16-Nov-12 8:25am
View
I would rather have a table of marks against that user /student.
So MarkID, StudentID, Mark
and then do a sum based on that table.
That is how I would do it.
Rob Branaghan
14-Nov-12 11:59am
View
Basically what ever the div class or id is in the html, have that in a media type of print and have the color:black;
look at the example on that weblink given by E.F. Nijboer...
@media print
{
.my-div-i-want-white-text-to-be-black {font-family:times,serif;font-size:10px;color:black;}
}
Rob Branaghan
14-Nov-12 9:19am
View
You could create an SQL Stored Procedure that accepts a parameter which is comma seperated values.... but the issue with that is it isnt safe.
I would suggest not writing SQL like that, to be safe.....
Rob Branaghan
14-Nov-12 6:30am
View
I know this might sound a little strange, but being a dual language speaker, sometimes I don't know the word in my other language, and thereby use the English word. (I believe people refer to this as Double Dutch)
Perhaps restricting the allowed characters is not a good idea?
Rob Branaghan
14-Nov-12 6:26am
View
Your welcome :)
Rob Branaghan
13-Nov-12 17:20pm
View
Thanks Marcus :)
Rob Branaghan
13-Nov-12 7:40am
View
The reason I suggest using the delegate event, is you set it up so that when the user clicks the close button on the Usercontrol, it will first check to see if the delegate event isnt null, and if it isnt, you can then call the delegate event.
From your form you would then have added that delegate event to call an event on that form which you could then add the Close Selected tab.
Does that make sense?
Its almost as if you are just passing back to the main the fact the event occurred (if you did need to pass data, you could).
Rob Branaghan
13-Nov-12 7:22am
View
Cheers, the articles exist, but sometimes people don't know what to search for :)
Hope this helps them.
Rob Branaghan
26-Jun-12 8:41am
View
Wonder if we will get a FB Like button on comments soon :)
Rob Branaghan
13-Dec-11 4:13am
View
http://en.wikipedia.org/wiki/Over-the-air_programming Is this what you want to acheive?
Basically I use a webservice, and send data to the webservice which talks to the main db.
Rob Branaghan
9-Dec-11 12:25pm
View
Hi, Do you mean you wish to send changes you make from the MS-Access database to a client via the web?
I suppose you would want to look into Web services if this is the case.
Rob Branaghan
9-Dec-11 12:23pm
View
Why do you want to open the drawer from the printer? Shouldn't you open the drawer from code rather than the printer?
Rob Branaghan
16-Sep-11 11:24am
View
lol Awesome!
Rob Branaghan
16-Sep-11 11:21am
View
It seems as though this is something they are aware of.
http://ajaxcontroltoolkit.codeplex.com/workitem/25711
[^]
Rob Branaghan
15-Sep-11 12:10pm
View
What is it you are trying to do with this Listbox?
Are sort of data are you trying to display?
Rob Branaghan
4-Jul-11 9:59am
View
When you are testing in development environment, what is your virtual path compared to when it is deployed?
Rob Branaghan
10-Jun-11 5:29am
View
Exactly what have you tried?
How about an example?
Rob Branaghan
3-Jun-11 11:17am
View
Similar question here by you....
http://www.codeproject.com/Questions/198233/junior-web-application-developer.aspx
Rob Branaghan
3-Jun-11 11:15am
View
How long have you been programming for?
Rob Branaghan
3-Jun-11 10:05am
View
I swear I have seen this same code for days on different posts!!!
Rob Branaghan
3-Jun-11 6:39am
View
Check your Data Access Layer, and make sure that the datetime returned from your database isnt null or something.
(Just a guess)
Rob Branaghan
3-Jun-11 5:08am
View
Looks a little bit like this
http://www.cis.upenn.edu/~matuszek/cit594-2002/Assignments/5-expressions.html
Rob Branaghan
2-Jun-11 4:34am
View
Try copy and pasting into a new class in your app. Add your applications namespace.
And then try it to see if it works.
Is the computer you are trying to talk to on a domain? because you dont appear to be sending a domain?
Rob Branaghan
2-Jun-11 4:24am
View
Did you have a look at that Article?
Rob Branaghan
2-Jun-11 3:56am
View
Yeah I second that!!!
What Member7929750 is working on is more of a Project than a site! It will take a while by their lonesome!
Rob Branaghan
1-Jun-11 9:07am
View
Its ok, Its just that some people will down vote your question for it. Just thought I would give you a heads up.
On the subject of your question, try downloading a starter kit and learn how it is written. You can buy books that go with the starter kits from amazon.
Rob Branaghan
1-Jun-11 9:03am
View
Good tip, dont put that it is really urgent, it winds some people up on here.
Rob Branaghan
1-Jun-11 4:10am
View
Yeah it would just be a warning. :)
Rob Branaghan
1-Jun-11 4:08am
View
Thank you, my little son is 3 months old now :) There are so many variables in parenting! :P
Rob Branaghan
31-May-11 12:05pm
View
Do you mean you want to be able do something like either Hide the button on load if a certain criteria is met? or change its appearance in some way?
Rob Branaghan
31-May-11 10:09am
View
Showing how to use the Math.Pow() function........
Rob Branaghan
31-May-11 8:50am
View
Cant you rewrite using XML? it would be far easier! OR save a Prefix and Suffix to each line
Rob Branaghan
31-May-11 8:44am
View
Looking at the way your code reads, be very careful of SQL Injections!
Rob Branaghan
31-May-11 8:17am
View
Deleted
Ok without seeing the code that is erroring, thats going to be very hard, apart from
3) Basically you arent using the variable. So it is redundant, you can remove this variable and then this error will go.
6) You need to either check it is NOT NULL before you use it, OR, initialize it with some content.
for example
Dim i as Integer = 0
rather than
Dim i as Integer
I believe if you click on the error it will take you to the line of code where the issue lies.
Also, buy yourself a version of Resharper with VB Support. That could help you.
Rob Branaghan
29-May-11 4:02am
View
By client area do you mean their desktop outside of your form?
I think you could add a margin to your grid or canvas, set the form border to none and then set the main window to glass. that way it would have a glass surround.
Rob Branaghan
29-May-11 4:00am
View
Upload your image to photobucket or something similar and then use that link.
http://www.photobucket.com/
Rob Branaghan
29-May-11 3:54am
View
Thank you :)
Rob Branaghan
29-May-11 3:54am
View
Thank you :)
Rob Branaghan
29-May-11 3:53am
View
If you want to UPDATE a record that already exists, use UPDATE. If you want to INSERT a new record use INSERT. If your table has "NON NULL" fields you will have to populate those as well.
Rob Branaghan
27-May-11 9:29am
View
Im glad I could help!
Rob Branaghan
27-May-11 8:00am
View
One thing though to note.... this allows SQL INjection to work. AS i managed to drop a database by sending a where statement of "1=1; Drop database destroyable; --"
So if you are going to allow a user to enter their own where statements, make sure that you protect against SQL Injection.
Rob Branaghan
27-May-11 7:32am
View
I managed to write a stored procedure that does what you need.
/*
Details
|0|DynamicStoredProc|0x|
|1||1x|
|2|1|2x|
Creator
|4||4x|
|3|Robert Branaghan @ Love2Code Ltd|3x|
Modified
|5||5x|
|6||6x|
|7||7x|
*/
CREATE PROCEDURE DynamicStoredProc
-- Add the parameters for the stored procedure here
@Select varchar(500) = '',
@Table varchar(500) = '',
@Where varchar(500) = ''
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
DECLARE @Query varchar(500)
SET @Query = 'SELECT ' + @Select + ' FROM ' + @Table
if LEN(@Where) > 0
BEGIN
SET @Query = @Query + ' WHERE ' + @Where
END
EXEC(@Query)
END
Rob Branaghan
27-May-11 7:00am
View
I suppose you could do it where you then combine all the selected items from that list into a string and then select that in the sql, I dont like doing that though, I prefer to use stored procedures.
Rob Branaghan
27-May-11 6:46am
View
Are these fields like for example...
Table : Person
#################
Field : FirstName
Field : LastName
Field : Age
#################
And you want to have FirstName or Age selected and then generate SQL from that?
Is that what you mean?
Cant you just return all the information and then in the background vb code populate the datagrid view or what ever?
Rob Branaghan
27-May-11 6:42am
View
Your welcome.
Good luck :)
Rob Branaghan
27-May-11 6:40am
View
Try the connection strings website, it will help you build it up
If the Database is on a remote server the connection string needs to tell it where that is, whether it be by IP address and port or computer name if on local domain.
Rob Branaghan
27-May-11 6:31am
View
Ok, so your remote database is where, somewhere else in the world? (Such as a hosted database)
And when you connect to it from a website it works.
Is this website it works from on the same server as the database?
Rob Branaghan
27-May-11 5:26am
View
:) Thank you :)
Rob Branaghan
27-May-11 4:42am
View
I believe what they are asking is
"Why doesnt the drop down list value save?"
Rob Branaghan
27-May-11 4:06am
View
Well basically using arrays is like owning a Ford. Using lists is like owning a Bentley!
Lists offer more power (in my eyes, and if someone believes otherwise so be it).
Rob Branaghan
26-May-11 12:20pm
View
The inheritance of Training makes me wonder. But I think using the Generic List it will improve what they can do with the Data. (Cant get enough of Lists)
Rob Branaghan
26-May-11 12:14pm
View
Did that make sense for you to use the List<Training> as it is easier to add items to?
Rob Branaghan
26-May-11 11:48am
View
I prefer to use Generic Lists these days with classes that reflect the object or item.
And is a hell of a lot easier to use
Rob Branaghan
26-May-11 5:41am
View
Saved me writting it so 5/5 :D
Rob Branaghan
26-May-11 5:35am
View
Do you currently pre load the images?
Would using silverlight be any good?
Rob Branaghan
26-May-11 5:32am
View
Damn, beat me to it! :)
Rob Branaghan
26-May-11 5:26am
View
Why dont you just concatenate them with a comma seperator?
Any particular reason why you want them all in one column?
Rob Branaghan
23-May-11 14:41pm
View
I cant edit it, but this is what I make of it.
How do i open a project which is written in C# that I have moved, I deleted it and moved it to another location but when I try and open the project it doesnt have a design view form and the design code has dissapeared.
How can I get the project to open properly.
Rob Branaghan
20-May-11 6:13am
View
How is it stored in the database? is it saved as binary, or does it just save the link to the pdf on the server?
Rob Branaghan
20-May-11 6:08am
View
What is the structure of your table?
Are Countries in a seperate table to City?
Try and explain to us as if we have never heard of the project you are working on.... Because we havent.
Are you really sure you want to delete them as well, surely flagging as deleted is a little less final!
To get assistance here you need to give us more information than that.
Rob Branaghan
19-May-11 5:46am
View
Set the report properties to be 2 or 3 columns, how ever many you need.
Rob Branaghan
18-May-11 7:54am
View
Why do 3 applications need the same variables?
Are they all part of one business function?
Rob Branaghan
16-May-11 5:25am
View
Is this WebPages? Winforms? WPF?
Rob Branaghan
13-May-11 4:09am
View
Thank you :)
Rob Branaghan
12-May-11 9:30am
View
bsb25 Check my solution, if you add this to your stored procedure / function, you can set the 50 and 60 to be two parameters. so you could say select where rowthing between x and y.
Rob Branaghan
12-May-11 9:23am
View
Try that now
Rob Branaghan
29-Apr-11 18:16pm
View
Ok is it 1 video per page? Like Youtube?
If it is, you could do it on load. so as it loads up you could have an asp literal and set it to be the programatically.
Have you got an address to the site that it will become?
Rob Branaghan
29-Apr-11 5:24am
View
Seems like quite a big project if you are a beginner!
What area of this are you struggling with?
Rob Branaghan
28-Apr-11 10:39am
View
Are you asking us to design the system for you?
Just think about it in steps of what you want to achieve.
Rob Branaghan
28-Apr-11 8:33am
View
Can I just ask why you want to round it to 4 decimal places, then do it back the other way to 8?
Rob Branaghan
28-Apr-11 6:13am
View
Your welcome! Glad I could help :)
Rob Branaghan
27-Apr-11 4:43am
View
What type of Database?
Is it MySql? Oracle? MSSQL? Access?
Rob Branaghan
27-Apr-11 4:07am
View
Your welcome, good luck with the website! :)
Rob Branaghan
26-Apr-11 10:24am
View
Updated my post with a few more links.
Rob Branaghan
26-Apr-11 10:03am
View
Ps your welcome for the answer :)
Rob Branaghan
26-Apr-11 10:03am
View
What format will the videos be? flv? wmv? mp4?
http://www.sothinkmedia.com/guide/putvideo.htm
On that page it shows how to embed flash videos, what you could do is on load bind the location to be the file path of the video.
Would you be showing 1 video per page?
If so, you could use the code they demonstrate but using the binding.
Rob Branaghan
26-Apr-11 9:07am
View
Can you edit this post Chander_Rani so it comes through correctly.
And if you need help with the C#, can you post this here also?
Thank you
Rob Branaghan
26-Apr-11 8:33am
View
Doesnt it have to store the edited text without HTML tags?
so instead of storing < it would store &-lt; (minus the -)
(CodeProject keeps converting it to the code)
Rob Branaghan
26-Apr-11 6:37am
View
Perhaps you may have to create a user control for this?
Rob Branaghan
18-Apr-11 6:03am
View
Oops! I suppose there is an onBlur event...
Rob Branaghan
18-Apr-11 5:55am
View
Thanks for your input. Will keep that in mind.
Rob Branaghan
4-Feb-11 5:48am
View
Could you move the function / subroutine to a helper class and call it with both pages from there?
Rob Branaghan
31-Jan-11 14:07pm
View
Hi Alex,
Do you mean P2P? Or will you have a webservice that will pass this xml file to your pc?
What do you want this application to do in total?
Do you want to transfer xml file from a pc to a remote pc?
Does the user know this is going to happen?
Rob Branaghan
31-Jan-11 13:45pm
View
The CodeProject user wants to log in USING the database.
Anyways
Vishalzala, Do you have a password to access your database?
I would suggest visiting this website. http://www.connectionstrings.com/access-2007 this shows you what connection string to use.
Rob Branaghan
10-Dec-10 8:34am
View
Another issue can be some servers only allow emails to go out if either the TO or FROM email address is one of theirs.
Rob Branaghan
1-Jul-10 8:16am
View
Reason for my vote of 1
Sounds unlawful
Rob Branaghan
30-Jun-10 8:56am
View
Good, Im glad you sorted out your problem :)
Rob Branaghan
30-Jun-10 4:26am
View
I am a little concerned that it is deleting the information from the database when you select and item! That would tell me there is a huge problem with your SQL!
Rob Branaghan
29-Jun-10 8:07am
View
When its running on the server, is your web.config file setup correctly with the SMTP settings?
Rob Branaghan
29-Jun-10 8:00am
View
So basically you have 3 or more drop downs with values 'A,B,C,D,E,F,G'
You want Each drop down to show 'A,B,C,D,E,F,G'.
But, when selecting a value (Lets say 'D') in the first Drop Down, you want the other 2 drop downs to show 'A,B,C,E,F,G'?
Is that what you are asking for?
Rob Branaghan
29-Jun-10 7:56am
View
Are you wanting the SQL for the Login as well? Is that what you are asking?
Rob Branaghan
29-Jun-10 6:58am
View
Have you checked to make sure you have AutoEventWireup="false"?
I found that with a gridview, the update command on a textbox would not update with the value in the textbox as it refreshed the page before updating.
Make sure you set the AutoEventWireup = false and that should work.
You will need to have OnLoad events and Databinds though.
ListView1.Databind();
Rob Branaghan
29-Jun-10 6:34am
View
Have you tried adding a textbox that cannot shrink or grow to enforce the white space?
Rob Branaghan
29-Jun-10 5:58am
View
http://p2p.wrox.com/book-beginning-visual-c/38178-check-if-cell-blank-excel.html
Scroll down that page, they said to test if the value2 is null rather than to string first?
Rob Branaghan
29-Jun-10 5:27am
View
Is this something like one of those links you click to get a link to a site (Link exchange)
Where there is a button that says "Generate Link Back" and the user clicks it, and it creates the HTML that the user would paste onto their site to hotlink your image and link back with a unique code?
Just a guess!
Rob Branaghan
29-Jun-10 4:41am
View
What exactly isnt working?
which area?
Rob Branaghan
29-Jun-10 4:27am
View
Just a wild shot in the Dark, can you use Try Catch in Excel in C#?
string firstName = "";
try
{
firstName = ((Microsoft.Office.Interop.Excel.Range)workSheet.Cells[rowIndex, colIndex1]).Value2.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString();
}
I havent really tried much in excel, but at least you should get the reason why your getting the error from that catch if it works?
Rob Branaghan
28-Jun-10 4:38am
View
What are you trying to Achieve?
Rob Branaghan
27-Jun-10 5:50am
View
You could look here on CodeProject for Serialisation XML and so on.
http://www.codeproject.com/KB/XML/xml_serializationasp.aspx (This is in C#, but there are converters online if you cannot understand C#)
Basically for the techician that asked for the XML, generate a file from your XML that you would send to the server, save the XML using XMLWriter or another method.
Rob Branaghan
27-Jun-10 5:42am
View
What are you trying to achieve from your webservice.
What it looks like from that bit of code is that you are using SQL to get a list of items and they are paths to images or something. Am I correct?
Are you trying to create something that you send XML to (Containing Parameters, Stored Procedure Name and so on) and then the service unpacks this xml and then runs the stored procedure, and then the results are then put into xml and returned.
Is that what you are attempting to do?
Rob Branaghan
25-Jun-10 7:28am
View
You could use a table and then group it on the repeated field.
For example if you were returning persons name and hours worked you could have
Fred 8, Fred 9, Fred3, John 10, Robert 3, Fred 1, John 4.
If you did a Group on Persons name (or better still an ID Number or other unique id of that person / item) You can group Freds hours and have a sum of them, or even a drill down so you can see what hours Fred did on seperate days.
What is the data you are trying to do a report for, what is the SQL. If you can tell me what you are trying to do exactly, and include your SQL I may be able to help.
Rob Branaghan
25-Jun-10 6:48am
View
So you are using BIDS?
If so, Do you mean you need to put filters in a text box or something similar?
(As in when you click on Expression, you see an expression builder waiting for some code?)
If you are using the Expression Builder in SSRS BIDS then you need to start what ever your doing with '='
For example
="This string " & vbcrlf & "Is over two lines"
or
= IIF(1+1 > 1, "Hmmm maths doesnt seem right", "I Knew 1+1 was more than 1!")
Show More